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 No comments

53 answers

Sort by: Oldest
  1. Anonymous
    2016-02-01T18:50:50+00:00

    Same problem here. Im not here to give any suggestions on this stuff thought, thats a job for the million dollars salary microsoft's program design engineers. Plus, people have to much in life as to be expending hours od tgeir precious time on trying to solve the problem of such an oligopoly. Thats why we pay them by buying their products and services. We should be moving forwards not backward. And today more that ever, time is too much of a valuable resouce, and to be efficient in this competitive world, speed is critical. So when desinging or upgrading a software, it's all.about speed.  Integrity brought microsoft to become the monster company that its today. If they want to claim to be the integral company that we thought we think of they, they should step up and refund every penney spent by hard working people on this thing, or else just fix the problem you created and save us all some headache. Do nothing and sooner that later we will all be looking at products from china or elsewhere.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2016-04-14T13:03:58+00:00

    I'm sorry to hear that you all are encountering these performance issues.  A couple of questions.

    First question: are you experiencing this on all workbooks or just on some?  If on some, are you filtering on that workbook?

    Second question: Are you using the 32 bit or 64 bit version of office?

    Third question: Are you using Win10?  If so you might have a bad video driver which could affect a number of functions within Excel.  To determine if this is indeed the case, please do the following and see if you still encounter the issue:

    1.Boot Microsoft Excel

    2.Click File > Options > Advanced.

    3.Under Display, turn on the "Disable hardware graphics acceleration" check box.

    4.Quit Excel

    5.Re-boot Excel

    If the video driver was the issue you shouldn't see the problem anymore.

    If that does solve the issue, re-enable the setting and then go to the following post to see how to update your driver:

    http://answers.microsoft.com/en-us/office/forum/office\_2016-word/fixed-11516-excel-word-or-outlook-problems-caused/6305c25e-b855-4621-8936-978f0d5dec91

    Bob Archer

    Microsoft Excel Team

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2016-04-19T00:02:51+00:00

    Bob,

    Certainly appreciate you looking into this. I had already disabled graphics acceleration. Besides, the comparison was performed on an out-of-the-box Surface Pro 3, with i5 processor and Win10. So the comparative test is done on only one computer, works very good with the old version of Excel on this Surface Pro. Hard to believe its graphic drivers are wrong, too, since both the computer and the software are Microsoft products.

    Unfortunately, I can't install Office97 on Win10, I guess it has 16 bit installers or something, so I run it on XP on a virtual drive (Oracle VM VirtualBox) on the Surface Pro. It works great. Also, Excel 2010 seems to have no problem running my "test" program at a reasonable speed (a Monte Carlo simulation, see earlier post).

    I have installed 32 bit Office 365, but it is a 64 bit computer, of course.

    There's also a wait state item (wowspl or something like that) that has to be cleared first through Task Manager whenever Excel2016 is run.

    Too bad there isn't a switch to run it in Excel97 mode (keeping all the mathematical error corrections that came with the more recent versions, of course). I don't use much of those bells and whistles on the new version, so wouldn't miss them, if it made it run faster.

    Regards,

    Dave

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2016-04-19T03:39:19+00:00

    Nice investigation.

    It appears your problem installing Office 97 on win 10 is that you are running 64 bit win.  You can run 32 bit Win 10 on your 64 bit hardware. 32 bit Win will limit RAM to 4GB. Check out the options in this article:

    https://www.infopackets.com/news/9815/how-run-16-bit-programs-windows-10-64-bit

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2016-04-20T15:35:57+00:00

    Nice investigation.

    It appears your problem installing Office 97 on win 10 is that you are running 64 bit win.  You can run 32 bit Win 10 on your 64 bit hardware. 32 bit Win will limit RAM to 4GB. Check out the options in this article:

    https://www.infopackets.com/news/9815/how-run-16-bit-programs-windows-10-64-bit

    True, same issue I had with Windows 7 Ultimate. But I just ran XP on it, which was included with it, on Windows virtual drive. I should have ordered Win 10 32 bit, but the virtual box works just fine, too. Thanks for your suggestion. -Dave

    Was this answer helpful?

    0 comments No comments