Use Pivot Tables and Slicers on Protected Worksheets

Excel File: https://www.teachexcel.com/excel-tutorial/2457/use-pivot-tables-and-slicers-on-protected-worksheets?nav=yt
Excel Courses: https://www.teachexcel.com/premium-courses/?src=youtube_v__KUGZ3BXeAxo

How to allow the use of a Pivot Table and its Slicer on a worksheet that is protected.

This allows you to keep your data safe from the user while allowing them to still analyze the data, expand and collapse rows, and filter though all of the data in the Pivot Table.

This tip works if the worksheet is protected with or without a password and it should not interfere with any other part of the spreadsheet.

Other Resources:
Password Protect Worksheets (msft): https://support.microsoft.com/en-us/office/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6
Pivot Tables (msft): https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576

Excel Courses:
- VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php
- Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_KUGZ3BXeAxo
- Email Course: https://www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_KUGZ3BXeAxo

TeachExcel.com

#msexcel #howto #tutorial

Видео Use Pivot Tables and Slicers on Protected Worksheets канала TeachExcel