Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003 Hide PivotItems
I have just upgraded to Excel 2003. I have a Pivot Table which is created
using VBA code which worked fine prior to the upgrade. When the following bit of code executes, the incorrect PivotItem is made invisible: With ActiveSheet.PivotTables("PivotTable1").PivotFields ("State (seq)") .PivotItems("09 - Close").Visible = False End With Instead of "09 - Close" being made invisible, another item "01 - Open" is made invisible. Also, when manually checking items to be visible or invisible, sometimes the first and last items turn on/off with the Show all items check box. Is this a known issue? We've already installed the service pack. Are there any other fixes available? Thanks |
#2
|
|||
|
|||
Well I haven't found other posts where anyone else is experiencing this
problem. But my solution, for now is to make visible the item which is being hidden in error and to add another line to make the item I want hidden invisible, as follows: With ActiveSheet.PivotTables("PivotTable1").PivotFields ("State (seq)") .PivotItems("09 - Close").Visible = False .PivotItems("01 - Open").Visible = True .PivotItems("09 - Close").Visible = False End With "Lee" wrote: I have just upgraded to Excel 2003. I have a Pivot Table which is created using VBA code which worked fine prior to the upgrade. When the following bit of code executes, the incorrect PivotItem is made invisible: With ActiveSheet.PivotTables("PivotTable1").PivotFields ("State (seq)") .PivotItems("09 - Close").Visible = False End With Instead of "09 - Close" being made invisible, another item "01 - Open" is made invisible. Also, when manually checking items to be visible or invisible, sometimes the first and last items turn on/off with the Show all items check box. Is this a known issue? We've already installed the service pack. Are there any other fixes available? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) |