Pivot Table Source file


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.
 
Ad

Advertisements

D

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.
 
Ad

Advertisements

C

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.
 

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

Top