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? |
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? |
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 |
All times are GMT +1. The time now is 12:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com