IFERROR function from XL 2003 to 2007

[Terry]

File was created in XL2003, I had an "IFERROR(x,y)" VBA function
referenced in cell formula, see:

http://min.us/mvj137H

Now in XL2007, I removed the VBA "IFERROR" so as to use the built-in
IFERROR.

The problem is as you see in the picture,
XL2007 is NOT automatically using the built-in. (F9 does not work)

I have to manually "touch" the individual cell formula (like put in a
space after "=") to have the formula recalculate.

Please help , thanks

 

[Dave Peterson]

Untested.

How about just selecting all the cells
Hit ctrl-h (like Edit|Replace in xl2003 menus)
What: = (equal sign)
with: =
replace all

Then excel will see that you're "touching" each formula.