| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table: deleted source data
Is it a common practice to delete the source data for a Pivot Table?
Why do the Pivot Table maintain the data after the source is deleted? I was trying to reverse engineer a Pivot Table that was created in 2009. I kept seeing the source as a Summary sheet but it was not listed in the spreadsheet. I thought it was hidden and it was not.. So I experimented a little and created a Pivot and deleted the source and the data stayed in place but kept displaying the source that did not exist. Thanks, Ty |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Data-Deleted Data still appears | Excel Discussion (Misc queries) | |||
| Data Field Items deleted when unchecked in Pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| I have deleted the Source data for a pivot table, how do I get it. | Charts and Charting in Excel | |||
Threaded Mode
