updating linked cells
 

I've recently updated to office 2003, and I'm having trouble with
Excel. the problem is with worksheets that do not automatically
update the results of new cell entries. For example, If I add a new
value in a cell that is in a range that calculates the average of that
range, the new value is not automatically included in the calculation,
although the formula indicates that it should be. the only fix that
I've been able to come up with is to go to every cell and update it
manually by double-clicking it. This is extremely irritating! Any
suggestions? This was not a problem in Office 97 (?) which the
spreadsheet was created. Thanks.

Do you have auto calculation enabled? Tools/Options/Calculation?Automatic

--
Ken Russell


Remove yourhat to reply by e-mail
..

"pnc1221" wrote in message
m...
I've recently updated to office 2003, and I'm having trouble with
Excel. the problem is with worksheets that do not automatically
update the results of new cell entries. For example, If I add a new
value in a cell that is in a range that calculates the average of that
range, the new value is not automatically included in the calculation,
although the formula indicates that it should be. the only fix that
I've been able to come up with is to go to every cell and update it
manually by double-clicking it. This is extremely irritating! Any
suggestions? This was not a problem in Office 97 (?) which the
spreadsheet was created. Thanks.

that did it. Thanks