Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't clear saved data in Pivottables
1. I loaded a pivot table with data from an External Source (SQL Server)
2. I had the Table OPtion save data with table layout. so the data saves with the table layout. 3. I change the underlying query to look at another data source. 4. I uncheck the save data with table layout option and save the file. close the file and reopen it, click refresh data. 5.The saved data from the first data source is still in the pivot table with the new data from the second source.....any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear a cell's contents when document is saved | Excel Discussion (Misc queries) | |||
How do I sort data in PivotTables in Excel 2000? | Excel Discussion (Misc queries) | |||
PivotTables - Calculations based on generated summary data | Excel Discussion (Misc queries) | |||
PivotTables: Restricting access to Report Filter Pages sheet data | Excel Discussion (Misc queries) | |||
Pivottables - Can i consolidate 2 Data sources in Excel 2007? | Excel Discussion (Misc queries) |