Excel calculation function lags the worksheet

Question

I have a file which is about 500kb in size, not too big, and whenever it's doing auto calculation, the worksheet becomes unresponsive. I have to turn it to manual to make it work. I have cleared office cache and re-installed office but the issue persist. Is there anything else I can do?

Answer 1

The issue has been found. It was caused by adobe add-in. After disabling it, it works as normal.

Answer 2

Hi @LLS, 

Thank you for posting your question in the Microsoft Q&A forum. 

To better understand what might be causing the slowdown during automatic calculation, could you please provide a few more details? 

• Which version of Excel are you using (Excel for desktop, Excel for the web, and the version/build number)? 
• Does the issue occur only with this specific workbook, or does it happen with other workbooks as well? 
• Approximately how many worksheets, formulas, and rows/columns are contained in the file? 
• Are there any complex formulas in the workbook, such as VLOOKUP, XLOOKUP, INDEX/MATCH, SUMPRODUCT, array formulas, or volatile functions like OFFSET, INDIRECT, TODAY, NOW, RAND, or RANDBETWEEN? 
• Does the workbook contain external links, Power Query connections, PivotTables, or VBA macros? 
• Is the workbook stored locally on your device, or is it located on OneDrive, SharePoint, or a network drive? 
• Does the issue affect other users who open the same workbook, or only your account/device? 
• In addition, could you let us know whether the workbook was recently modified before the problem started (for example, new formulas, data imports, macros, or additional worksheets)? 

If possible, please also share a screenshot of the workbook structure (sheet tabs and formula examples) while removing any sensitive information. This will help us narrow down the root cause and provide more targeted troubleshooting steps. 

Thank you again for your time and understanding. If there’s anything else I can assist you with, please don’t hesitate to let me know. I’m here to help.     

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.