Dynamically updating Pivot tables

Hi
I have a question that I've been trying solve for some time now and wondered if anyone had the answer?

I have several worksheets in a workbook that are updated daily with the latest information; the data from these worksheet are "Pivotted" to form a summary of the information. In order to get realistic averages in one particular Pivot I filter out anything that is "0" (ie zero) however when the worksheets are updated the filter on the Pivot continues to ignore the "0" but also any number that has been subsequently added - I have to go into each Pivot filter, select "All" and then deselect "0".

Is there any way that the Pivot can be made to IGNORE all "0" but INCLUDE and subsequent non-0 number without having to refresh the filter? This is not a big issue for me but others that use the spreadsheet often forget to do the refresh of the filter so are in danger of reporting the wrong figures

Thanks in advance for any suggestions.

The DNR works great (once I'd sorted out the formula to use!), thanks again. Now to try incorporating the macro

It's been a few days since I've been able to look at this again, but I've not managed to get the macro to work (I'm very much a VB novice!).

I have put the code into the VBA, with the "Object" set as Workbook and the "Procedure" set as Activate, and saved the file as Excel Macro-Enabled Workbook, however the Pivots do not refresh when I go into the respective worksheets. I'm obviously doing something very basic in error, but not sure what - any suggestions as to what the school boy may be?