IFERROR function from XL 2003 to 2007

[matelot]

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

[davesexcel]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[martindwilson]

i know what you mean, if you just put
iferror(a1+b1,"") in an excel workbook pre 2007 you get name# error, opening it in 2007 it stays the same.(so the fact you have a macro resolving it is irrelevant)
just select the column with the formulas in
then use text to columns from the data tab,select delimited ,click finish that should force it to re-calc. repeat for other columns