Open to Blank Pivot Table Data (Excel 2007)

[Hutch]

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]

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]

Thanks. Actually, I don't want it to auto refresh, and most people unless
they have the file setup in a trusted location can't refresh until the clear
the security warning. Therefore, they see the data sitting there until they
clear the security warning and it auto refreshes.

If there was a way to bypass the security warning it would be nice.

However, for other purposes I would like the table blank upon opening.