I have a message "calculate" - how to resolve this issue ?

[Jack]

In left-down corrner I have a message "calculate" and when I create new
formula it does't calculate at all. I have no links to other files. I have to
save the file each time I want new formula to be calculated or press "enter"
on the cell. How to find the mistake in the file in order to get rid of the
message "calculate".
Thanks

 

[Niek Otten]

It's all explained here:

http://www.decisionmodels.com/calcsecretsf.htm

 

[Ms-Exl-Learner]

Try this…

Tools>Options>Calculation> change it to “Automaticâ€
Click the Office Ribbon Button>Excel Options>Formulas> change it to
“Automaticâ€

If this post helps, Click Yes!

 

[Ms-Exl-Learner]

I forget to mention the Version of Excel...

Try this…

Excel 2003 - Tools>Options>Calculation> change it to “Automaticâ€

Excel 2007 - Click the Office Ribbon Button>Excel Options>Formulas> change
it to
“Automaticâ€

If this post helps, Click Yes!

 

[Judy]

Ms-Exl-Learner - Thank you - Thank you - Thank you. The Excel 2007 Office
Ribbon Button and so on, was most helpful to me. I appreciate the knowledge.

 

[Ms-Exl-Learner]

You're Welcome!