Pivot Tables and Macros

  • Thread starter Thread starter JG
  • Start date Start date
J

JG

Hi (Question from a newbie Maroc user),

I'm trying to record a macro which builds a pivot table and also creates a
chart though it keeps failing when I run it. Can anyone point me to general
info on macros and pivot tables or offer suggestions on common issues I
should be aware of when do this? Any help appreciated.

thanx.
JG
 
What errors do you get when you run the macro?
When you record a macro, it remembers the name that was assigned to the
first pivot table, and when you run the macro again, it tries to use the
same name. If the active sheet has a pivot table with that name, you'll
get an error message. If that's the problem, select a different sheet
before running the macro, or change the code so it assigns a different name.
 
Back
Top