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
Bookmarks