#DIV/0 Error in a PIVOT - It's gone and I can't re-add!!!

Hi all,

This is my first post on this forum so please go easy on me!

Background
I have created customized league tables in Excel 2010 with formulas that specifically look for '#DIV/0' errors in a percentage column I have in pivot tables in a separate tab (=IFERROR etc).

Problem:
For some reason, the pivots are no longer showing the '#DIV/0' error, even though they should be - the raw data is clearly a row of 0's and thus the error should be returned. I have ensured that the 'For Error Values Show' box is unchecked in Pivot Table Options, but unfortunately this isn't working.

I know there is a lot of help on the net for turning OFF this error feature in Pivots, but what about turning it back on?

Any help is greatly appreciated.

Thanks,

Dan