View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
bhofsetz[_93_] bhofsetz[_93_] is offline
external usenet poster
 
Posts: 1
Default Omit page with no data when use "show page"


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