Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Pivot Table row heading (blank) with no data in it | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot Table Changes the Source Data Range | Excel Discussion (Misc queries) | |||
pivot table excel 2007 -- show rows with no data | Excel Discussion (Misc queries) | |||
Pivot Table Data Column Sort Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 pivot table data is truncated | Excel Discussion (Misc queries) |