Share via

Excel 365, Calculating (8 threads), lag time = unproductive

Anonymous
2022-03-01T17:16:55+00:00

I have a very large file, 40KB, with a LOT of different formulas.

I am basically building a tool/small database within Excel for use.

All of a sudden I started seeing the calculating (8 threads) message and the lag time is unbearable.

  • I cleared contents in unused rows/columns
  • I do not have formulas that look up an entire row/column
  • workbook includes - 9 tabs, all with different info
  • largest tab uses 1500 row out to column BS.
  • Power Query connects additional information from outside the file.

Any advise on how best to troubleshoot?

Your knowledge is welcomed and revered.

Thanks

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-03-03T08:30:16+00:00

Hi JRo_Kemp

Thanks for your response. I ‘m following this thread.

As you mentioned the issue was happened in a specific workbook, may I know if you try to copy the all content to a new workbook to check the result, did it work?

Besides, we require you to use  Repair an Office application (microsoft.com) to check if the issue can be solved.

Disable all Excel add-ins>File>Options>Add-ins>then disable them to check the result. You can still enable them later on if you need them again.

Meanwhile, I did some researches and find an article about calculations , you can refer to Excel performance - Improving calculation performance | Microsoft Docs to see if it can give you some ideas.

Appreciate your patience and understanding.

Regards,

Stacey

Was this answer helpful?

10+ people found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-03-01T17:41:00+00:00

    Hi JRo_Kemp,

    First, my pleasure to assist you.

    As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

    May I know does issue happened do specific Excel document? If the issue only happens to a specific file, the file may be corrupted. In this scenario, please copy/paste content to a new created Excel file, then check the outcomes.

     If the issue happens to all Excel files including a new created one, the issue is more related to the Office app itself or your computer environment.

     May I know have you tried to click "calculate now" under Formula tab in Excel. Also please try go File>Options>Advanced and under Formula turn on the multi-threaded formula calculation of excel and check the outcomes.

    In the meantime, to confirm whether this is a bug in a specific version, please provide us the version information. To check version: Open Excel>File>Account>Product Information and capture a full screenshot and share here (Please mask your private message for protecting your private message) and we will be tested on that version and verify the result with you.

    I appreciate your understanding and stay safe!!

    Best regards

    Waqas Muhammad

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-03-03T18:34:30+00:00

    Hello.

    Some questions or/and remarks:

    40 KB seems not to be a large file. Is the size correct?

    You are using lots of formulas but no VBA coding?

    You are trying to build a database application without programming?

    Did the performance drop suddenly with any changes or did it get less performing over time (more formulas, more data)?

    Kind Regards

    Gerhard

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2022-03-01T19:57:15+00:00

    Hello Waqas,

    Thank you for trying to assist me with my excel issue.

    My issue is specific to this excel doc.

    The multi thread option is selected, at 8

    When I select "calculate now" it's very very slow to calc

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments