Effects of Macros on Pivot Tables

J

Jody

I know absolutely nothing about macros, but was teaching someone pivot tables
and she asked if macros have an effect on Pivot Tables???????????
 
J

JE McGimpsey

Jody said:
I know absolutely nothing about macros, but was teaching someone pivot tables
and she asked if macros have an effect on Pivot Tables???????????
Click to expand...

They certainly have an effect to the extent that they (a) change the
Pivot Table object directly (you can build and modify PTs using
VBA/Applescript), (b) modify the underlying data (though the change
won't show up unless the PT is refreshed), or (c) delete or
significantly modify the worksheet that the PT exists in.
 

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

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
Write back from pivot table 1
Write back from pivot table 0
Pivot Table cell values 1
Macro to copy table of contents to a new doc 0
Effects of Macros on Pivot Tables 1
Pivot table 0

Top