Open to Blank Pivot Table Data (Excel 2007)

  • Thread starter Thread starter Hutch
  • Start date Start date
H

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?
 
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.
 
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.
 
Back
Top