Ask a new question

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

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

Answer
Answer

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

------------
Beware of Scammers posting fake Support Numbers here.
Please let us know if this is helpful and if the solution worked for you, as it can benefit others who are facing the same scenario.

7 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 16, 2024 Views 81,465 Applies to: