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
Bookmarks