Paul, that does the trick, thanks !
On Dec 2, 12:23 pm, Paul Schreiner wrote:
> If "touching" the cell works, then simply do a find/replace
> and replace iferror with iferror.
>
> they all should recalculate then.
>
> Paul
--
-
Excel-Macros$$ IFERROR function from XL 2003 to 2007
>
>
> 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
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
