| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide calculatedField
How do you hide a calculatedfield in a pivottable?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you hide/un-hide the grid lines | Excel Discussion (Misc queries) | |||
| Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
| How do I hide hide #REF! in Excel | Excel Discussion (Misc queries) | |||
| Solve Order of a CalculatedField in a Pivot Table | Excel Discussion (Misc queries) | |||
| How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
Linear Mode
