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 thos
sheets
--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile:
http://www.excelforum.com/member.php...fo&userid=1880
View this thread:
http://www.excelforum.com/showthread.php?threadid=38117