Pivot Table Error

L

Linda

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.
 
T

Tom Ogilvy

CurrentPage is only applicable for pivotfields that are acting as
pagefields. Is that your situation? Is ALL CONDITIONS and actual
pivotitem value?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Pivot Table Error 1
Format Pivot total rows 2
pivot table macro with a filtering variable 3
Using macro to switch 'page' in a pivot table? 1
VBA Pivot Table Change Criteria - Help?! 1
Changing the CurrentPage items in a Pivot Table 1
RunTime Error 1004? _Default Property? 4
Update Pivot Table Filters based on a Cell Value in Excel 2007 0

Top