I have software that creates a data dump of a bunch of information; pivot
tables work great for helping us sort information. Our customer has seen and
now requested similar reports. The pop down feature makes it nice to isolate
a particular group or all of them.

I have deleted the "source" file and password protected the worksheet with a
password. And it is locked. However, if you click the wizard again, and
choose the layout, you can repopulate the pivot table with the data we don't
want them to get at.

The only way I have been able to comply it to copy the sheet and paste it
back as a dead spreadsheet.

There has to be something I am missing with a setting to protect my data,
but still offer reports that they can use for sorting.

If anyone can help, I would appreciate it.