Instead of trying to hide the data, set the pivot table to refresh
automatically when someone opens the file.

In the Data tab of the PivotTable Options, add a check mark to Refresh
Data When Opening the File.


Hutch wrote:
I am wanting a user to open a file to a blank pivot table that has all of the
columns and rows defined, but they have to refresh the table for data to
appear. In PivotTable options I have:

* unchecked to save source data w/ the file
* set the number of records to retain per field as none

However, when someone opens the file I send them it is still showing data.
However, if I try to interact w/ the data I get an error the table was saved
w/o underlying data so I will have to do a refresh. Therefore, my previous
two settings seem to be working right except for it retaining a snapshot of
the data from when it was last saved.

Any thoughts?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com