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

--
Regards,
Tom Ogilvy


"Baileys Cigs" <Baileys wrote in message
...
I want to create a macro that lets you change the arrangement of a pivot
table. Need to know where to begin.

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


"Tom Ogilvy" wrote in message
...
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

--
Regards,
Tom Ogilvy


"Baileys Cigs" <Baileys wrote in message
...
I want to create a macro that lets you change the arrangement of a pivot
table. Need to know where to begin.