Default to Automatic calculation

kleetus51

New Member
Joined
Sep 30, 2019
Messages
5
Recently and inexplicably any new workbooks that I open default to manual calculation. I read a few message boards and they said that the solution is to put a workbook in the XLSTART folder that s set to automatic calculation. This works, however any time I open an existing workbook it opens this one too. I then have to close that one out, which is a minor inconvenience but annoying nonetheless. Is there a way to have Excel default to automatic calculation without going this route? Alternatively, is there a way to make the workbook in XLSTART not open when I open an existing file?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,747
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Excel's calculation mode is determined by the first workbook opened. Typically, if it's loading in manual calculation, that is due to either the personal macro workbook or a book.xltx template file. Do you have either of those?
 

kleetus51

New Member
Joined
Sep 30, 2019
Messages
5
I don't have anything in my XLSTART folder except for the workbook I referenced above. I'm not sure how to check for a personal macro workbook, as I've never used those before.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,747
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
There are actually two XLSTART folders - which one are you looking in?
 

kleetus51

New Member
Joined
Sep 30, 2019
Messages
5

ADVERTISEMENT

C:\Users\lefd01\AppData\Roaming\Microsoft\Excel\XLSTART. I didn't find another one. Where is it typically located?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,747
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Somewhere within the program files\microsoft office folder hierarchy.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,070
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile

ADVERTISEMENT

In my 365 it is in C:\Program Files\Microsoft Office\root\Office16
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,747
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
If you start Excel in safe mode (hold down the Ctrl key while starting the application), does it start with automatic calculation enabled? If so, then there must be something being loaded at startup that sets calculation to manual. Since we've ruled out the XLSTART folders, I'd see what add-ins you have loaded.
 

kleetus51

New Member
Joined
Sep 30, 2019
Messages
5
It does start with auto calc turned on in safe mode. I'll look into the add-ins and see if I can figure out which one is doing it. thanks for your help!
 

Watch MrExcel Video

Forum statistics

Threads
1,130,281
Messages
5,641,293
Members
417,202
Latest member
AndyVBA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top