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