Debra Dalgleish has written code for this

http://groups.google.es/advanced_gro...=lang_en&hl=en

search for hide zero value pivot table and in author put Debra Dalgleish

--
Regards,

Peo Sjoblom

(No private emails please)


"Rob" wrote in message
...
Hi,

Using Windows 2000 and Excel 2000

I have created a pivot table which correctly shows the data returned,
however, I don't want to show entries where the total (sum of data) is
equal to 0 (a zero). I've tried to turn on Filter but this option isn't
available.

Any pointers most welcome.

Rob