| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you turn off Calculate mode in excel?
I have just copied a series of values from an excel worksheet into a new
file. Unfortunately in the bottom left corner of the screen it states 'Calculate' and when I enter formulas you have to double click and hit enter before the work sheet updates the value. Can anyone explain how I get the sheet to update automatically? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you turn off Calculate mode in excel?
Under Tools-Options, Calculation tab.
You can switch from Automatic to Manual. Note that when you are in Manual mode, you can press F9 to perform a calculation. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "James Aumonier" wrote: I have just copied a series of values from an excel worksheet into a new file. Unfortunately in the bottom left corner of the screen it states 'Calculate' and when I enter formulas you have to double click and hit enter before the work sheet updates the value. Can anyone explain how I get the sheet to update automatically? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you turn off Calculate mode in excel?
For EXCEL 2007 this would be:-
Office Button / Excel Options (lower right hand corner) / Formulas / Calculation options (at the top pf the page). "Luke M" wrote: Under Tools-Options, Calculation tab. You can switch from Automatic to Manual. Note that when you are in Manual mode, you can press F9 to perform a calculation. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "James Aumonier" wrote: I have just copied a series of values from an excel worksheet into a new file. Unfortunately in the bottom left corner of the screen it states 'Calculate' and when I enter formulas you have to double click and hit enter before the work sheet updates the value. Can anyone explain how I get the sheet to update automatically? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you turn off Calculate mode in excel?
Many thanks Luke, that's cracked it.
Regards James "Luke M" wrote: Under Tools-Options, Calculation tab. You can switch from Automatic to Manual. Note that when you are in Manual mode, you can press F9 to perform a calculation. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "James Aumonier" wrote: I have just copied a series of values from an excel worksheet into a new file. Unfortunately in the bottom left corner of the screen it states 'Calculate' and when I enter formulas you have to double click and hit enter before the work sheet updates the value. Can anyone explain how I get the sheet to update automatically? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I turn off compatibility mode in Excel 2007? | Excel Discussion (Misc queries) | |||
| How do I turn off [Group] mode? | Excel Discussion (Misc queries) | |||
| How can I turn off the [VSync] mode in my excel file? | Excel Worksheet Functions | |||
| How do i turn on audit toolbar (buttons are in off mode)? | Excel Discussion (Misc queries) | |||
| how to turn off design mode | Excel Worksheet Functions | |||
Linear Mode
