Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |