Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I have deleted the Source data for a pivot table, how do I get it.
I have deleted the source data that is linked to a Pivot Table, I still have
the table but no data - can I get it back? |
#2
|
|||
|
|||
Unless you saved a backup, it's doubtful.
"Sarah" wrote in message ... I have deleted the source data that is linked to a Pivot Table, I still have the table but no data - can I get it back? |
#3
|
|||
|
|||
Perhaps you can get it back, if the pivot table was saved with the
underlying data. In the Pivot Table, set the row, column and page fields to show All. Double-click on the Grand Total cell, and it may create a sheet with the source data. Sarah wrote: I have deleted the source data that is linked to a Pivot Table, I still have the table but no data - can I get it back? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table data | Excel Discussion (Misc queries) | |||
Pivot and changing External data source | Excel Discussion (Misc queries) | |||
pivot table in data source order | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |