Problem adding pagefield to a pivot table using VBA

[lynnsong986]

Hello,

I encountered a weird thing using the below codes:

pt.AddFields PageFields:="Description"
pt.AddFields RowFields:=Array("Date2", "Description2")

after I ran the first line, the PT did add the page field, but after I ran the second line, the pagefield was removed and the two rowfields were added. Same thing happened when I changed the order of the two lines (adding rowfields first then pagefields, this time, the rowfields were removed and only the pagefield remains)


does anyone know how to fix this?

thanks!

[Pepe Le Mokko]

Perhaps posting your entire code ( with code tags) and your sheet would help us help you?

[Andy Pope]

The addFields adds Row. Column and Page fields all at one go.

If you then use another .AddFields instruction it will replace all 3 with information provided. If you don't provide information for any one of them the field will be removed.

[lynnsong986]

I had to code this with recorded codes and it works. would you please let me know how to get around this so both can stay?

thanks so much for your time!

[Andy Pope]

Please Login or Register  to view this content.

[lynnsong986]

thanks so much for your help!!