Thread: Pivot Table Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Linda Linda is offline
external usenet poster
  
Posts: 7
Default 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.
Reply With QuoteReply With Quote