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" <Sarah@discussions.microsoft.com> wrote in message
news:CF758B76-68F4-4F06-8489-C5D120EB51BB@microsoft.com...
> 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