Pivot Table Orientation = xlHidden

[StuLux]

I have recorded VBA code as follows:

    ActiveSheet.PivotTables("Months").PivotFields("YTD Var").Orientation = xlHidden

but I get the error "Unable to set the orientation property of the PiuvotField class"

Anybody know why - all I can find suggests this is the correct way to hide a field in a pivot table?

 

[pnoonan]

I know this is a very very old thread but I had a similar problem. So to help the next person, if the data field is a calculated data field (not sure if it was in the above post), in Excel 2007 the VBA code recorded by the macro recorder when you remove a calculated data field from a pivot table is something like:
ActiveSheet.PivotTables("My Pivot Table").PivotFields("My calculated field").Orientation = xlHidden
which works on a normal data field but for calculated fields when you run the macro it causes the Run-time error '1004': Unable to get the PivotFields property of the PivotTable class.
You can instead use:
ActiveSheet.PivotTables("My Pivot Table").PivotFields("My calculated field").Delete
(and if later on you need that calculated field again you have to add it again)

This thread helped:
http://social.msdn.microsoft.com/Forums/en/isvvba/thread/60fa78ed-0913-4bf5-9c47-2bc0eea59a2c

 

[pnoonan]

Oops, that error was actually
Run-time error '1004': Unable to set the Orientation property of the PivotField class
(see above post)