Formula not evaluated automaticly in Office 2003

H

Hz-man

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.
 
P

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
 
K

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 :)
------------------------------­------------------------------­----------------
 
Top