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.

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

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 :-)
------------------------------*------------------------------*----------------


"Hz-man" wrote in message
...
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.