+ Reply to Thread
Results 1 to 2 of 2

Set Calculation mode Manual to only one excel file

  1. #1
    Registered User
    Join Date
    10-02-2003
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    46

    Set Calculation mode Manual to only one excel file

    Dear Forum,
    Can I set one file to Manual calculation while leaving the others in Automatic calculation mode? I have an excel file that takes too long to calculate.
    Thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Set Calculation mode Manual to only one excel file

    Hi,
    You can do this by changing the workbook into a XLSM file and adding two event procedures in Visual Basic Editor (ALT+F11 to open):
    Please Login or Register  to view this content.
    If you are not familiar with VBA this will be a little difficult but not too much!
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] AUTO/MANUAL Calculation mode marker ?
    By KomicJ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2020, 02:49 AM
  2. [SOLVED] Chart macro for manual calculation mode
    By Sekars in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-19-2016, 02:17 AM
  3. force excel default settings to manual calculation mode
    By thosecars82 in forum Excel General
    Replies: 4
    Last Post: 12-27-2012, 07:34 AM
  4. Replies: 5
    Last Post: 08-14-2012, 01:31 PM
  5. Replies: 7
    Last Post: 07-09-2012, 05:42 AM
  6. Open CSV causes calculation in manual calc mode
    By kunkletown@comcast.net in forum Excel General
    Replies: 0
    Last Post: 07-25-2006, 04:30 PM
  7. [SOLVED] My Calculation Mode Changed to Manual Somehow?!?
    By Jeb in forum Excel General
    Replies: 2
    Last Post: 08-04-2005, 11:05 AM

Tags for this Thread

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