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. |
Formula not evaluated automaticly in Office 2003
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 |
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. |
All times are GMT +1. The time now is 04:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com