Unfortunately I only have Excel 2000 installed on this machine. Howeve
you can also try this: select any cell on the pivot table, go to th
'Format' menu, and select 'AutoFormat...'

--
Kre
-----------------------------------------------------------------------
Krem's Profile: http://www.excelforum.com/member.php...fo&userid=2434
View this thread: http://www.excelforum.com/showthread.php?threadid=37943