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.
Welcome!
Yep. Doesn’t seem to be a solution. The first copy is always ridiculously slow.
There’s more discussion here on the forum that you can search for.
Yes, it definitely is an issue. And it did not start with Office 365. I have experienced the same with Office 2011.
I have no solution to prevent this from happening. It is annoying.
It is astonishing how much better Excel works on Windows. I do not get why Microsoft is not able to deliver an experience that is as good on the Mac like it is on Windows.
I think that many Mac users do not realize that Microsoft Office on the Mac is still subpar in comparison to its Windows counterpart.
Yes, this is a known issue with Excel for Mac. There was extensive discussion of this a few weeks ago on the forum. See link below. Note that despite the post title it is not necessarily to do with KM, Alfred or Copied.