PIVOT Table Security - allow users to use/change filters etc use but prevent copying

KayB14

New Member
Joined
Jul 9, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hi All!

I really hope there's a way to do this as I've not had any luck figuring it out myself.

I am creating an interactive employee report containing PIVOT tables for users of to self-serve. I have protected the worksheet and workbook however as the PIVOT tables need to be accessible, they can easily be copied into a new workbook and therefore have its settings changed and access the background data. Is there a way to allow PIVOT table to be used but not copied outside the current workbook? Or at least prevent any way to access the background/source data?

The purpose of the report is to allow users to explore data and format the PIVOT in a way that is suitable for them. However, the need for this flexibility comes with the privacy/protection complications (to me anyway!).

Thanks so much! :)
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,175,897
Messages
5,900,131
Members
434,818
Latest member
ankurc_dk

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top