Pivot Table range source area reference

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hi,

Where/How can I see where my Pivot Table data is referencing?

I am using Excel 2003.

Thanks
 
This is from memory, so I hope it works for you.

From the Pivot table, activate the Pivot table wizard and select BACK. It
should show the source range there.
 
You must log in or register to reply here.

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

How can I change the source data reference to another pivot table? 2
Easy way to change Pivot table source files? 5
Pivot tables - memory issues - please help 2
Pivot Table (display source data) 3
Pivot Table with Data Model Connection - getpivotdata reference issue 0
pivot table source data expand to new entries when refresh? 4
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot table change data source 1

Back
Top