MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table Source

Posted by Phil Ruhnow on January 23, 2000 4:34 AM

My boss has set up a lot of files using pivot tables, and he is about to leave. (a genius, but not a teacher)
1. What is a good tutorial or primer on pivot tables?
2. How do you find out what file (his pivot tables are to some access file) the pivot table is getting its information from?
3. With multiple pivot tables in file, how do you know if all of the pivot tables have been refreshed, and where to go to refresh them?

Thanks in advance.

Posted by Denise on January 24, 2000 11:34 AM

Pivot Tables are pretty easy to manipulate and you should experiment
with them by moving fields around. When starting a pivot table, the
wizard walks you through every step and it's very easy
Go into the wizard and hit the "Back" button and it will show you the cells where your tables are sourced from.
Most likely, your boss has set up all the pivot tables to refresh at the same time. After you hit the refresh button, you'll get a window
that says your pivot tables have changed.

Posted by Phil on January 26, 2000 1:50 AM

Posted by Phil Ruhnow on January 26, 2000 1:51 AM

I think one of the problems is the linked file is on the network, and the "path" to the file is hidden somewhere?