I am trying to hide a "Page" option on a pivot table. I need to hide \
disable the "(all)" option and create another one with an accurate
calculation. I can handle making the other one but I cannot seem to
find a way to hide the "(all)" option. If anyone can provide any help
it would be greatly appreciated. I alredy tried making another "(all)"
section but it just lists 2 all sections on the page view drop down on
the pivot table. Thanks,

Garrett


--
nockam
------------------------------------------------------------------------
nockam's Profile: http://www.excelforum.com/member.php...o&userid=15744
View this thread: http://www.excelforum.com/showthread...hreadid=387229