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 |