+ Reply to Thread
Results 1 to 7 of 7

Change Auto Calc to Manual by default

  1. #1
    Registered User
    Join Date
    11-15-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    19

    Change Auto Calc to Manual by default

    Hi

    Whenever I open a fresh excel (2010), the calculation setting is Auto. Is there any way that I can set this to manual as a default so that everytime I open excel I dont have to go to options and change setting to manual. By default it should keep calculation setting to manual.

    Thanks

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: Change Auto Calc to Manual by default

    Office Button > Excel Options > Formulas > Workbook Calculations > Manual

    see if that works for you...
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: Change Auto Calc to Manual by default

    or look also here...
    look here:
    http://www.decisionmodels.com/calcsecretse.htm

    When Excel has no workbooks open, or when you start Excel, it sets the initial calculation mode and settings from the first non-template, non-addin, non-Personal.xls workbook that you open

    This means that the calculation mode setting in subsequently opened workbooks will be ignored, although you can change the mode yourself at any time using Tools-->Options-->Calculation. As soon as you change the calculation mode, it applies to all subsequently opened workbooks.

    If you want to override the way Excel sets the initial calculation mode you can set it yourself by creating a module in ThisWorkbook (doubleclick ThisWorkbook in the Project Explorer window in the VBE), and adding this code. This example sets calculation to Manual.
    Note that this will NOT prevent the workbook being recalculated if it is opened in Automatic mode.
    read more of this...

    Hth
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  4. #4
    Registered User
    Join Date
    11-15-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Change Auto Calc to Manual by default

    Quote Originally Posted by icestationzbra View Post
    Office Button > Excel Options > Formulas > Workbook Calculations > Manual

    see if that works for you...
    Hi

    Thanks for that but I already know this. I am wondering if we can change this setting to manual as default so that everytime i start excel i dont have to change it to manual from automatic.

    Thanks

  5. #5
    Registered User
    Join Date
    11-15-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Change Auto Calc to Manual by default

    Quote Originally Posted by vlady View Post
    or look also here...
    look here:
    http://www.decisionmodels.com/calcsecretse.htm


    read more of this...

    Hth
    Hi

    I tried but it didnt work.

    Thanks

  6. #6
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: Change Auto Calc to Manual by default

    try this one.
    find the xlstart/startup folder--> inside that you'll find a workbook maybe named book1 open it then do the option->calculation manual..save it ->then restart excel.

    let's see what happens

  7. #7
    Registered User
    Join Date
    11-15-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Change Auto Calc to Manual by default

    Quote Originally Posted by vlady View Post
    try this one.
    find the xlstart/startup folder--> inside that you'll find a workbook maybe named book1 open it then do the option->calculation manual..save it ->then restart excel.

    let's see what happens
    Sorry but cant find a startup folder in xlstart.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1