Hi,

I have a worksheet that no longer calculates any formulas until
hit save. Example: filling in a cell with a number, a sum formul
normally would do the calculation. I can change cells and the formula
won't do their functions. If I save the workbook, then all the formula
calculate and display the correct data.

If any one has any Ideas I could use the help.


Thank

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

ToolsOptionsCalculation. Re-set the "Auto-calculation".

Gord Dibben XL2002

On Thu, 20 Nov 2003 21:16:24 -0600, Sevcav
wrote:


Hi,

I have a worksheet that no longer calculates any formulas until I
hit save. Example: filling in a cell with a number, a sum formula
normally would do the calculation. I can change cells and the formulas
won't do their functions. If I save the workbook, then all the formulas
calculate and display the correct data.

If any one has any Ideas I could use the help.


Thanks


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/