Pivot Table Source file

  • Thread starter Thread starter cubbybear3
  • Start date Start date
C

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.
 
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.
 
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.
Click to expand...

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