Protect the source data of a pivot table

Please purchase the course before starting the lesson.

It is common for users to send summarised reports in the format of Pivot Tables where confidential information is hidden in the source data, but it is assumed that it is not visible in the Pivot Table. However, even if you created the pivot table from information in another workbook, Excel will remember the data source. So if you want to make sure that no one can see the raw data in a Pivot Table you need to follow some steps.

Lesson tags: vlookup
Back to: Excel for Human Resource and Payroll Personnel > Protecting spreadsheet information and formulas