Pivot Table Refresh Data - Extremely Urgent!!!! HELP

[James8309]

Hi everone.

This is really urgent for me. I have this spreadsheet and when I open
it. It has a pivot table and I normally update the data by right click
-> Refresh data.

Q: How do I find out where it is pulling the data to update from?


Your help will be most appreciated!!!

Regards

James

 

[Andrew R]

Hi James,

Data | Pivot Table, then select Back.

in 2007 click on the change data source and it will show you where it
is coming from