Pivot Tables and Macros
 

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

Pivot Tables and Macros
 

Hi JG:

A good website for pivots is Debra's Contextures. (www.Contextures.com).

--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand
Please do not forget to rate this reply.


"JG" wrote:

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

Pivot Tables and Macros
 

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.

JG wrote:
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.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html