Hide zero value lines within a pivot table in Excel 2003/XP/2000/97

Great article with screenshots.. Doesnt get any clearer than this:

Spreadsheet123.com

Too bad it doesnt work for rows adding up to 0 in the pivot (say source has a -10 and 10, so the pivot shows 0, the trick above doesn’t work for that)..

Hide All But One Sheet

Hide All But One Sheet

Loop through all sheets in a Workbook and hide all but Sheet1. Excel will not allow all sheets hidden.