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

S

Sarah

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?
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Write back from pivot table 1
Write back from pivot table 0
Create a dynamic master file 1
pivot table missing rows? 0
Consolidation Table from Different Excel Tabs with Different Format 1
Power Pivot. Yikes. 0
How to have two tables on same line? 1

Top