Formula not evaluated automaticly in Office 2003
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.
|