EXCEL 365 very slow movement after input data in cell

[raajnabriz]

Hi,

I have a workbook with many sheets, all the sheets are working fine but for one sheet that is very slow in movement from one cell to another after inputting a data or even when saved, the cursor gets busy for almost 10-15 seconds, kindly let me know how to solve this issue.

Thanks,
Riyaz.

 

[Anthony47]

My guess is that your formulas take that time to be recalculated.
You have to identify where are the bottlenecks and a different way to get the same results with more efficient formulas or approach

If you can share your workbook then for sure some concrete help will arrive.

Or: Excel performance - Improving calculation performance

Bye

 

[raajnabriz]

My guess is that your formulas take that time to be recalculated.
You have to identify where are the bottlenecks and a different way to get the same results with more efficient formulas or approach

If you can share your workbook then for sure some concrete help will arrive.

Or: Excel performance - Improving calculation performance

Bye

Thank you @Anthony47 will have a look into that, it will be a very tedious work though.

 

[raajnabriz]

Thank you @Anthony47 , I got the culprit that was slowing down my excel sheet.

 

[Anthony47]

Good... The Worksheet detective badge is yours

 

[raajnabriz]

Thank you @Anthony47