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???????????

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

Top