| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "excel "macros may be disabled" message using an xlam file | Excel Worksheet Functions | |||
| How do I resolve "too many different cell formats" error? | Excel Discussion (Misc queries) | |||
| Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
| WHY I GET " CALCULATE" MESSAGE | New Users to Excel | |||
| Resolve message "No more fonts may be applied to this work book" | Excel Discussion (Misc queries) | |||
Linear Mode
