Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Error
I am trying to set the pivot field value and am getting
the following error: Unable to set the _Default property of the Pivotitem class. The statement I am using to set it is: ActiveSheet.PivotTables("PivotTable1").Pivotfields ("COND").CurrentPage = "ALL CONDITIONS" I have the correct worksheet selected, and a cell within the pivot table is selected. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Error
CurrentPage is only applicable for pivotfields that are acting as
pagefields. Is that your situation? Is ALL CONDITIONS and actual pivotitem value? -- Regards, Tom Ogilvy "Linda" wrote in message ... I am trying to set the pivot field value and am getting the following error: Unable to set the _Default property of the Pivotitem class. The statement I am using to set it is: ActiveSheet.PivotTables("PivotTable1").Pivotfields ("COND").CurrentPage = "ALL CONDITIONS" I have the correct worksheet selected, and a cell within the pivot table is selected. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xml error in pivot table | Excel Discussion (Misc queries) | |||
Pivot table error | Excel Discussion (Misc queries) | |||
Pivot table error | Excel Worksheet Functions | |||
Pivot Table Error | Excel Discussion (Misc queries) | |||
Pivot table error | Excel Worksheet Functions |