Hide calculatedField

F

Frank Kabel

Hi Todd
have you tried recording a macro while doing this manually (removing
this field)
 
T

Todd Huttenstine

Yes here is the macro I recorded when I removed the
field...

ActiveSheet.PivotTables("PivotTable1").PivotFields
("Percent Overdue"). _
Orientation = xlHidden


Then I when I set the pivottable back to the way it was
right before the macro was run, and then run the macro
again, I get the error: "Run-time error '1004':
Unable to get the PivotFields property of the PivotTable
class"

This is why I think it may be an Excel or VBA glitch. Its
like the macro recorder is recording the wrong code.
 
T

Todd Huttenstine

Hey this is a bug. I looked on google groups and
websearch and it has been reported to Microsoft.


You cannot hide a calculatedfield programmatically.
 
Top