Is there any way to have manual calculation be on by default? Would this go in the personal.xls file in a macro that runs when the file opens? I have a colleague that loses a lot of time waiting for some huge spreadsheets to update and gets frustrated with it.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Permanent Manual Calculation
- Thread starter kkjensen
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
The way I do it is to set it to manual in Book.xlt, that forms the basis for the blank workbook you get when you start Excel.
Upvote
0
My friend has lots of files that he's inherited. He has a good machine (dual processor with 2.5GB of ram) for no reason since excel 2000 will crash long before his machine even starts to warm up. Is there any way to force an old file (that you've never opened before) to open in "manual" mode just to make sure that whatever problems might exist won't bring everything to a halt before he ever gets to look at the file?
Upvote
0
Oaktree
MrExcel MVP
- Joined
- Jun 20, 2002
- Messages
- 8,120
- Office Version
- 365
A couple of notes on calculation:
(1) All subsequently opened files will open at the current calculation setting
(2) Calculation settings are stored with the workbook. If you save a workbook as manual, it will open as manual. However, this is secondary to item (1) above.
(3) Since new workbooks in Excel default to automatic calculation (unless you change Book.xls as Andrew suggested), and Excel opens a new workbook upon startup (unless you change the setting), closing Book1 or whatever Excel defaulted to on startup BEFORE opening any files is a good way to ensure the calculation setting as in (2).
HTH
(1) All subsequently opened files will open at the current calculation setting
(2) Calculation settings are stored with the workbook. If you save a workbook as manual, it will open as manual. However, this is secondary to item (1) above.
(3) Since new workbooks in Excel default to automatic calculation (unless you change Book.xls as Andrew suggested), and Excel opens a new workbook upon startup (unless you change the setting), closing Book1 or whatever Excel defaulted to on startup BEFORE opening any files is a good way to ensure the calculation setting as in (2).
HTH
Upvote
0
Similar threads
- Question
