Excel gets slower/ramps up CPU usage as you scroll through and edit biggest worksheet

[ali_brook]

I have a problem that I find difficult to describe, so bear with me...

I am on Office 365 with Windows 10.

I have a workbook with 11 worksheets and 6 hidden worksheets that I use frequently as part of my job - I customise it and edit it to show the position of the products we sell. It can get to about 6MB in size.

What I have noticed recently is when I generate a larger file, as I scroll down the largest worksheet, editing as I go, it gets progressively slower the further you go down the sheet. At the start, I can overwrite cells instantaneously, but the further down the sheet you go, the slower it gets, and once you get past row ~1000 or so, it can take 10-15 seconds for the action to happen - even longer for copying and pasting multiple sales.

This has only started to happen fairly recently - within the last month.

Any help would be appreciated!

 

[offthelip]

Try doing the same thing while running with EXCEL offline. I know Office 365 has some problems with speed when connected to the internet.

 

[mayoung]

I have had issues like this myself. Go through each sheet and go to the last row. Once there select all cells below it. Then hit clear all. I have found there maybe trash in cells which cause the size of the document to be larger than what it should be. Then save, close and reopen. Then see what happens. Also check your workbook size before and after.

 

[Joe4]

If you have a lot of sheets with lots of data that is all connected/linked to each other, then what you really may have is a "relational database", and it may be time to start considering using a relational database program like Microsoft Access or SQL. They are designed for that sort of thing and generally perform much better.