Results 1 to 3 of 3

Thread: Excel lags when switching between automatic & Manual calculations
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2008
    Posts
    1,234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel lags when switching between automatic & Manual calculations

    wonder if anyone has a fix for this problem. it is not related to actual calculation time as the effect occurs even with a new blank sheet.

    I will do my best to explain and hope someone has come across the problem as well.

    With a new and blank sheet changing from Automatic to manual causes excel to freeze (Not responding) for 10-15 seconds. After the freeze you can swap between calc modes without delay.
    however selecting a random couple of cells and then changing calculation mode causes excel to freeze again.

    A few note and things I have tried
    Using Office 365 first noticed the problem in 2016.
    Forced through an upgrade to 2019 and the problem still occurred.
    I uninstalled and ran the MS Office cleanup tool then reinstalled - same problem
    All Add-ins disabled - same problem
    Excel Safe mode - - same problem

    Run excel as a different user on the same PC - No problem.
    Delete and recreate the user profile - Problem fixed!

    I thought that was the end of it....however another PC is having the exact same problem and I want to avoid recreating the user profile if possible.
    Does anyone have a suggestion what we can try?

  2. #2
    Board Regular
    Join Date
    Dec 2017
    Location
    UK
    Posts
    928
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Excel lags when switching between automatic & Manual calculations

    Have you checked your personal.xlsb file to see whether that is causing the problem, or any other workbook that starts up automatically.
    Speed up your code use variant arrays and NEVER ACCESS THE WORKSHEET IN A LOOP

  3. #3
    Board Regular
    Join Date
    Jun 2008
    Posts
    1,234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel lags when switching between automatic & Manual calculations

    yes, personal was deleted and recreated, no other workbooks open at the same time.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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