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!
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!