I have deleted the Source data for a pivot table, how do I get it.

[Guest]

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?

 

[Barb Reinhardt]

Unless you saved a backup, it's doubtful.

 

[Debra Dalgleish]

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.