Formula not evaluated automaticly in Office 2003

[Guest]

When I open av workbook made in Office XP, formulas with functions like
DEC2HEX do not evaluate until i click on the cell, klick in the functrion
edit box and press ENTER. And , yes, i have installed and selected all the
add-ins including the Analysis Tool Pack but it doesn't seem to matter. I
have also checked that evaluation shuld be Automatic. Is there some other
option that needs to be altered? This happens at about 3000 places in the
workbook so I can't do this by hand.

 

[Pete]

Highlight a column with formulae in it, then Data | Text-to-Columns
then click Finish. If this works then repeat it for other columns.

Hope this helps.

Pete

 

[Ken Wright]

Does CTRL+ALT+F9 do it?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------