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

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

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

It's all explained he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jack" wrote in message
...
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

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

Try this€¦

ToolsOptionsCalculation change it to €œAutomatic€�
Click the Office Ribbon ButtonExcel OptionsFormulas change it to
€œAutomatic€�

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"Jack" wrote:

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

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

I forget to mention the Version of Excel...

Try this€¦

Excel 2003 - ToolsOptionsCalculation change it to €œAutomatic€�

Excel 2007 - Click the Office Ribbon ButtonExcel OptionsFormulas change
it to
€œAutomatic€�

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"Ms-Exl-Learner" wrote:

Try this€¦

ToolsOptionsCalculation change it to €œAutomatic€�
Click the Office Ribbon ButtonExcel OptionsFormulas change it to
€œAutomatic€�

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"Jack" wrote:

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

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

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" wrote:

Try this€¦

ToolsOptionsCalculation change it to €œAutomatic€�
Click the Office Ribbon ButtonExcel OptionsFormulas change it to
€œAutomatic€�

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"Jack" wrote:

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

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

You're Welcome!

--------------------
(Ms-Exl-Learner)
--------------------



"Judy" wrote:


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" wrote:

Try this€¦

ToolsOptionsCalculation change it to €œAutomatic€�
Click the Office Ribbon ButtonExcel OptionsFormulas change it to
€œAutomatic€�

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"Jack" wrote:

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