Not the same cell. Is it any object to describe the grand total of pivot
table? So i can check if the grand total equals zero then delete the sheets.

"bhofsetz" wrote:


Is the grand total in the same cell on each pivot table created?

If so then you can check to see if this cell is 0 and delete those
sheets.


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=381176