changing pivot table views with a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a macro that lets you change the arrangement of a pivot
table. Need to know where to begin.
 
Turn on the macro recorder and make the changes to the pivot table manually.
Turn off the macro recorder and look at the recorded code. This should be
where to begin.

Some more information may be found at Debra Dalgleish's site

http://www.contextures.com/tiptech.html

Look under P
 
I have the same problem
This example is verry important to my but it do not work in Excel 2003 wiht
a OLAP data.
http://www.contextures.com/xlPivot03.html#ShowSpec97

the error is:
Can not get the property PivotFields of the class PivotTable in the line

Set pf = pt.PivotFields(strPF)


other erro in the line: "pi.Visible = True"
is: "Can not asign the property visible of the class PivotItem"


Thank you for your help
 
You must log in or register to reply here.

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

macro 4
How I can set dynamic pivot table ONLY when I have enough data point 1
Playing back a Pivot Table macros 2
Unable to Group in Pivot Table 1
Pivot table and it's macro 1
Pivot Table Refreshing 2
modified pivot table using a macro 2
Pivot Table Question 2

Back
Top