Where is pivot table data?

S

srpd

I created several pivot tables months ago, all linked to one master data
sheet. Now it's time to update and I can't find the master. The Field List
and Filter Pane appear, so they're still linked. Where can I find the address
of the master sheet?
 
J

Jim Thomlinson

Right click the pivot and select Wizard. Use the Back button to move to the
dialog where the data range was specified. Note that it is possible to delete
the source data range or sheet and the pivot table will remain intact. The
pivot ultimately has it's own memory known as the pivot cache.
 

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

Adding to an existing Pivot Table 7
Usings Text fields in a Pivot Table 1
Pivot Table - cells imported as 'Blank' 2
pivot table data 2
Pivot tables - memory issues - please help 2
Pasted Pivot Table looks at old sheet 1
Pivot Table inquiry 1
Group in Multiple Pivot table 1

Top