View Single Post
  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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