Pivot Tables and Macros

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
 
D

Debra Dalgleish

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.
 

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

do macros not like pivot tables? 1
Pivot Tables and Macros 2
code to delete all rows beneath and columns right of pivot table 3
Pivot tables macro 1
Excel 2007 pivot tables - calculated fields and SSAS cube 3
chart from pivot data, and sheet data? 5
Pivot Tables by Macro 2
Creating Pivot Tables inside a Macro 4

Top