ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel - "Automatic Calculation" (https://www.excelbanter.com/excel-discussion-misc-queries/11534-excel-%22automatic-calculation%22.html)

NewUser

Excel - "Automatic Calculation"
 
How to setup "Automatic Calculation" as the default setting?

Ken Russell

Tools/Options/Calculation/Automatic

--
Ken Russell


Remove yourhat to reply by e-mail
..

"NewUser" wrote in message
...
How to setup "Automatic Calculation" as the default setting?




Jim Rech

Excel always opens in auto calc mode, but the calc mode setting in the first
workbook opened will change it to manual if that's how it is set. The first
workbook opened includes any that automatically open when Excel starts, like
Personal.xls if you have one. If you do, make sure that whenever you resave
it calc mode is auto at that time.

--
Jim Rech
Excel MVP
"NewUser" wrote in message
...
| How to setup "Automatic Calculation" as the default setting?




All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com