Excel Office 365 2016 So Slow that I cannot use it

This is a Global problem message to a few is unacceptable,

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.  

I have a particularly large spreadsheet, with macros, references across different worksheets in it, etc. About 11Mb in size. It also uses iteration to converge to solutions in some parts, with 6000 iterations (it's a Monte Carlo run). I have a desktop computer equipped with Windows 7. My copy of Office97 would not load on this 64 bit build of 7, so I run it on a XP virtual disk, ON THE EXACT SAME HARDWARE. Office 365 I subscribed to a couple of weeks ago, and run it on Windows 7 Ultimate.

In XP, this workbook takes about 15 seconds to run.  In Office 365, it's 75 seconds, but before you can even get going, you have to go into Resource Monitor and clear the wait-chain for some printing polling item. What a pain!  (I also have a Surface Pro 3 (i3) with Office 365 on Windows 10, and you have to do the exact same clearing of the printer wait-chain item to make it work, too, and it takes equally long to run. That is not a true apples-to-apples comparison since it is a different machine, but is more evidence to me that there is something intrinsically screwed up in Excel 2016.)  I can put the following line at the beginning of the code in the workbook, but it doesn't seem to help with speed:

Application.PrintCommunication = False

Anyway, I think instead of making all these peripheral suggestions Microsoft makes that just obfuscate the point (reminds me of the techniques used by car dealer service managers to avoid doing anything to fix your defective car), I hope Microsoft take the growing evidence of poorer performance (and more importantly, our dissatisfaction with it) and fixes Excel. From my admittedly unscientific comparison, Excel 2016 takes 5 times as long to do the exact same computation, on the exact same machine, as Excel97. Is this just a ploy to make us all buy new, even more powerful computers, just to keep the status quo? All the shiny baubles and fancy graphics can go away as far as I am concerned, if that is part of the issue, especially that cumbersome ribbon. (Guess which version of Excel I use when I really need to get something done!)

Dave

Are there any path or fixed, this complain has been there since forever.. What is Microsoft doing. This has reduced productivity greatly

Hi,

In relation to improving XL performance, we have sent Private messages to some thread participants requesting additional information.

As long as everything is designed to run on the Cloud and use the Internet, I'm sure this issue will only get worse. I imagine Microsoft intends to eventually eliminate VBA as an option in Excel, for the same reason. Which is Internet security. A shame to dumb e

verything down like this.

When I need to do anything serious, I use my old version, for which I still have the installation disk. Remember those?

I have an surface pro 4 I7 16 Gig internal RAM.

Same problem: slower, slow build up of the screen

In office 2010 no problem with performance. filesize: 25Mb

Also thinking to reinstall office 2010.

Your hardware specifications are much more than adequate to run Office.  The problem you are seeing is a bad interaction between the part of Word that "draws" Word on the screen and some undefined part of Windows.

The problem first showed up in Word 2013 (I also saw it in Excel 2013). At that time the Word team had completely replaced that part, "subsystem", of Word with a "new & improved" version. Since then MS has released a number of fixes for very specific situations.

If you read through the question you'll see there are a number of suggestions that have worked for other people. The most common suggestion is to switch the current "Hardware Acceleration" setting(s) (Either in Word and/or Windows).