Serious performance issues with Microsoft Excel 2021 (The are there since 2010 and never got fixed)

Question

Serious performance issues with Microsoft Excel 2021 (The are there since 2010 and never got fixed)

Anonymous

I have been an office user for a long time, And I have learnt that you can't give excel too much data, else it will go into the annoying ""Not responding"" state, now here's an example, I pasted a list of 200,000.00 email in column A Using Shortcut "Alt + H, V, V, and excel 2021 went freezing, Now I sometimes believe that it will come to life eventually, however after 10 minutes of waiting, I opened my task manager, and please MS look for yourself, Excel isn't doing anything, not even using more than 8% of CPU.

I was seriously hoping that performance issues might have been fixed in the latest office, however alas!, I have no idea how couldn't they not notice that "Excel is slower, sluggish and is not ideal for larger data at all". I have to initiate this post, so it could get fixed at the soonest.

Preferred Fix: Make Excel Use full Power of the CPU and if Possible the GPU too.......... to finish off tasks like a breeze........

There are more than a million rows and columns, At least make excel able to process this much data.

Thank you!!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

Welcome to the new world of programming Excel, where workarounds the stupidly slow new releases is a primary goal. I've just recently downloaded in Beta 2202 and its so much slower than the previous 2201 which was way slower than the older 1905 and earlier. I've had to disable automatic calculation for after about 20 minutes of about 2k data updating a column it would get so slow then go unresponsive then the whole freaking program would crash and burn, starting over. Then I found a really weird bug than no one at Microsoft could solve - when using .Value(11) in VBA that would mysteriously switch the Automatic Calculation back on. Took days to figure that one out.

Lately, some rather simple copy routines that copy formulas and formats from one cell to another would make Excel go into what appears to be some sort of wild loop. Specifically:

r = 20 ' starting row 

For i = 0 To 30 'check to see if the cell is colored 

    If Main.Cells(i + 1, 21).Interior.ColorIndex &gt; 0 Then 

        Main.Cells(r, 2) = Main.Cells(i + 1, 21).Value 

        Main.Cells(r, 3).Formula = "=v" & i + 1 

        Main.Cells(i + 1, 22).Copy 

        Main.Cells(r, 3).PasteSpecial Paste:=xlPasteFormats 

        r = r + 1 

    End If 

Next

This "for next" takes up to 3 minutes to do!!?? In order 1905 and earlier you could even see it happen. Now you can see the cells change, then stopping after each of the steps, for maybe a 2 seconds or so. Its absurdly slow, sometimes it just hangs in Unresponsive state about a quarter of the time then Excel will just crash - no notice just blink out then restart. Its becoming awful waste of time so much so I am considering going to Google Docs, learning their macro coding.

Answer 2

Hi UmairAziz,

Welcome to Microsoft Community and thank you for sharing your concern with us today.

I understand that Serious performance issues with Microsoft Excel 2021 (The are there since 2010 and never got fixed). I am glad to offer you help on this issue.

Microsoft Excel could be a bit of a struggle to handle such a large amount of data. If you want to report back to Microsoft, you could press Windows + F to submit your request to Microsoft.

And there is an alternative tool at your disposal. "Access", it could process that much data.

I hope the information provided is useful for you. If you have any additional questions, please do not hesitate to reach out to our support.

Best Regard,

Kevin | Microsoft Community Support Specialist

*Beware of scammers posting fake support numbers here."

*Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

Share via

Serious performance issues with Microsoft Excel 2021 (The are there since 2010 and never got fixed)

2 answers