Formula Problem

[tdunbar]

Hello,

I am new here so apologies in advance if this was covered, couldn't find it on a search. I inherited a worksheet that has formula like:

Cell A1 = $8.04 and Cell A2 = A1/12 which gives the value of $0.67. The problem is when the value in A1 is changed the result in A2 does not adjust. This is the problem for all the formulas in the entire workbook. Is the sheet locked or something? Please advise.

Thanks.

-Tom

 

[joelnichols]

Calculate is set to auto? Sounds like its on manual

Look in Tools|Options|Calculations auto

 

[tdunbar]

That did it. Thank you!! To be honest, I have used excel alot and didn't know that option existed. To many choices!! Thanks again.

 

[joelnichols]

Your welcome.