Has anyone experienced slowness when copying cells in Excel Office 365?
Originally, I thought that it was because I was using a 2012 MacBook Pro but I recently upgraded to the latest MacBook Pro with 32Gb of ram so I now know that it can’t be the computer.
In small spreadsheets, the issue is not noticeable but as soon as I am using a spreadsheet which is, say over 2Mb, there is a considerable lag when trying to copy anything. On very large spreadsheets, I will even see a spinning ball.
The issue is very easy to replicate:
- Open a new workbook
- Create a sequence from 1 to 80 in row 1
- Copy row 1 to all the rows to about row 22,000
- This will create a workbook of about 5Mb in size
Now try copying any cell or cells and notice that there is delay until Excel will allow you to paste the copied cells into another location.
Like most here, I run a lot of utilities such as Alfred 4. I have tried the test after quitting Alfred and there may be a slight improvement but there is still a significant lag.
I would be interested if anyone has experienced this issue and managed to solve the problem.