Excel formulas not updating

[Jeffrey Campbell]

HI folks, I am not an excel professional so bear with me. 

I use a simple spreadsheet that we've developed over the years to enter certain data into and answer yes or no questions. Based on this information, formulas in other cells calculate costs and time. The end result is our estimate (Ballpark). This has served us well for many years... gradual improvements over that time.

Today the worksheet has decided not to automatically calculate the formulas. Old results remain after changing other cells. UNLESS I click on the cell with the formula (double click) and hit Enter. Then the cell updates the figures. Needless to say this is a pain in the butt. 

Anyone experience this before and is there a quick fix?

thanks in advance.

Jeff

[#2]

Hi Jeffrey,

It seems that the calculation option is set to manual!

So, please go to:

Formulas >> Calculation >> Calculation Options >> Automatic

Regards

[#3]

BINGO!

Thanks a lot. Not sure how that got changed because I didn't even know it was an option.

Awesome help though... and quick response! Love it!

Jeff

[#4]

@Jeffrey Campbell 
When I link to other spreadsheets, sometimes I have to DELETE (the cells with the LINKS) and SHIFT LEFT to get clean cells to that the links to other spreadsheets start updating again.