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