Pivot Table Source file

[cubbybear3]

I have been doing VBA in Excel for years, but have never done anything
with Pivot Tables. I was given a spreadsheet that has 4 pivot tables
which grab data from our main system (AS/400). How do I find what
files are being used when the P/T's are refreshed?
Thanks for any help.
-Paul B.

 

[Dave Peterson]

You may be able to select a PT, then show the PT wizard.

Then click on the Back button to see the settings.

This may not apply to you, but when I did stuff like this, I'd have a text file
created from the AS/400. Then I'd import that data into excel and do all the
manipulation from that imported data (maybe some clean up before the PT
processing started, too).

I'd often convert the PT's to values and delete the imported data. But
sometimes, I'd leave the data, but hide the worksheet with that data.

 

[cubbybear3]

You may be able to select a PT, then show the PT wizard.

Then click on the Back button to see the settings.

This may not apply to you, but when I did stuff like this, I'd have a text file
created from the AS/400.  Then I'd import that data into excel and do all the
manipulation from that imported data (maybe some clean up before the PT
processing started, too).

I'd often convert the PT's to values and delete the imported data.  But
sometimes, I'd leave the data, but hide the worksheet with that data.

Thanks Dave. That got me to the SQL source. Had to point it to a new
library/file on the 400.