Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel displaying formulae as constant and not calculating formula
When entering a formula directly into a cell (starting with =) the formula
does not calculate, rather the formula is displayed in the cell as if it were just text. The only way I have managed to get the formula to calculate is to make a mistake in the formula and let the 'There is an error in the formula you typed, do you want to accept the correction' dialog correct the formula. Can anyone explain how to fix this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel displaying formulae as constant and not calculating formula
2 thoughts 1) the cells are not formated to text and so not performing calculations 2) you have automatic calculation turned on in your options -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=513072 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel displaying formulae as constant and not calculating formula
2) you have automatic calculation turned on in your options
Think Dav meant: 2) you *do not* have automatic calculation turned on in your options To quickly check/ensure that calc mode is set to auto, via: Click Tools Options Calculation tab Check "Automatic" OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|