Hide calculatedField

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
Hi Todd
have you tried recording a macro while doing this manually (removing
this field)
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Syntax 3
Pivot table calculated field 3
Can't use a calculated field in the same SQL code's WHERE clause 3
Excel 97 & Pivot Table 3
Excel Program Glitch? 5
How many IIF statements can I use in a expression within a query? 11
Hide Pivottable GrandTotal using VB 4
Calculated field in subform not returned in parent in v.2003 1

Back
Top