Hide calculatedField
 

How do you hide a calculatedfield in a pivottable?

Hide calculatedField
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Todd Huttenstine wrote:
How do you hide a calculatedfield in a pivottable?

Hide calculatedField
 

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.


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

--
Regards
Frank Kabel
Frankfurt, Germany


Todd Huttenstine wrote:
How do you hide a calculatedfield in a pivottable?

.

Hide calculatedField
 

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.



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

--
Regards
Frank Kabel
Frankfurt, Germany


Todd Huttenstine wrote:
How do you hide a calculatedfield in a pivottable?

.