Hello,
I have got a macro that creates a pivot table, I want to set the table
for default display by selecting one of the options in a field
selection list. For example the field "Year" has got 3 possible
selections (All), 2005, 2006. I want to set the value to 2006.
Recording the action gave me this:-
ActiveSheet.PivotTables("Report").PivotFields("Yea r").CurrentPage = _
"2006"
I inserted this at the end of my existing macro but get the error
"Unable to set the _Default property of the PivotItem class". I
thought this would be a simple addition but cannot seem to get around
this problem.
Any ideas gratefully received.
Thanks.
--
Des
------------------------------------------------------------------------
Des's Profile:
http://www.excelforum.com/member.php...o&userid=34154
View this thread:
http://www.excelforum.com/showthread...hreadid=542429