Excel Office 365 2016 So Slow that I cannot use it

Anonymous
2015-10-30T19:44:34+00:00

I upgraded five personal household computers to Windows 10 last week and upgraded my Office 365 subscription to 2016.  Now all five laptops are having major issues running Excel.  Excel is very slow moving between cells and when I copy a large amount of data to new sheet, I have time to play a round of tennis before Excel responds.  Excel is too slow to use anymore.  

I have researched the issue for past 7 days and tried every recommended fix without success.  Apparently a great many users are having similar issues with Excel Office 365 2016.  Preparing to try out Google Docs spreadsheet... anyone using that?

I even brought an old PC out of mothballs with Windows 7 Ultimate but when I installed Office 365 2016 Excel had same slow running issues.  I suspect my Excel problems are in Office 365 2016.  How do I revert back to Office 365 2013? 

I am surprised Microsoft launched Office 365 2016 with this major issue on Excel.

Microsoft 365 and Office | Excel | For home | Windows

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

53 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2016-08-12T10:16:40+00:00

    I have actually been in touch with Microsoft support about this issue, and they have got some way in finding the issue. It turns out to be a call to some Office interoperability DLL (I can't recall the name) that keeps timing out after a few seconds. They are still trying to find the particular function(s) in my spreadsheet that are triggering this call to the DLL, but I will try to remember to post a reply here once they find the offending function(s).

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-08-13T03:46:12+00:00

    "...makes only milliseconds of difference with one call, but in those cases where code runs, protecting and unprotecting many sheets, it all adds up to a terrible performance issue. 

    Because it is considered a security risk to modify that, all request for a change have been turned down. The development team will never do anything to make Office less secure."

    What's the point of secure if MS has rendered Excel useless for real work and transformed it into just a pretty way to show tables and graphs? We already have PowerPoint for that sort of thing.

    Excel is so widespread that it is conceivable it's impacting productivity nationally, something the Fed and economists are starting to worry about.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-09-26T15:56:51+00:00

    Microsoft need to look into excel 2016.

    This is too slow.

    i have tried all suggestion i can find on this platform to no avail.

    Microsoft team should test with large volume data and provide solution.

    Its frustrating using excel since i migrated to office 365 and using Microsoft 2016.

    i have wasted 100s of hours

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-11-03T00:34:39+00:00

    The lack of a fix response to this thread tells you all you need to know about how buried in the software this bug is. I am running on a new NUC with 16GB and W10 Prof, Office 365. I am struggling to even do a Save As. So, what to do? My answer is to move to Google Sheets and not renew Office365. Making unusable software. Bring back Bill!

    Was this answer helpful?

    0 comments
  5. Anonymous
    2017-02-01T21:28:52+00:00

    Hi Bob

    Disabling 'hardware graphics acceleration' makes Excel 2016 work properly on my Win10 machine. 

    Re-enabling it makes the problem return.

    I downloaded the win10 update but it made no difference.  I then downloaded the driver update as suggested, but the problem with slow movement between cells still persists and Excel is horrible to use.

    Any more suggestions?

    Regards

    Rodel5465

    Was this answer helpful?

    0 comments