Hi all,

within a (Excel 2000) pivot table, I'd like to hide all items except of
one, which is named 'Total'.
The item list can change, so hiding item by item does not work.The
function could look like:

..PivotItem.Visible = False
..PivotItem("Total").Visible = True

I am looking for a function to hide all items at once. Any ides?

Best regards & thanks for help,
the Excelgeek


--
Excelgeek
------------------------------------------------------------------------
Excelgeek's Profile: http://www.excelforum.com/member.php...o&userid=24285
View this thread: http://www.excelforum.com/showthread...hreadid=378940