Hi,

I am trying to hide the "All" option from being visible to the user in
page fields in the Pivot chart.

Whenever there are more than 1 fields chosen in the page field, excel
automatically adds "All" field to the page fields value list. We want
to hide it.

Any help is appreciated.

Regards,
Amit


--
amit2505
------------------------------------------------------------------------
amit2505's Profile: http://www.excelforum.com/member.php...o&userid=36219
View this thread: http://www.excelforum.com/showthread...hreadid=560106