A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
So, how did you restrict the conditional formatting if you still needed to apply it to the 3 columns?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
So, how did you restrict the conditional formatting if you still needed to apply it to the 3 columns?
What happens to this topic ? Did you got any response ?
Actually in my case I need to use Excel via the interop library. Am I doomed for this now or do you know if microsoft is fixing this issue also for the interop dll ?
Best regards
I have an Office 365 subscription and ran into the same problem of an unacceptable slowing down of Excel. I tried most of the solutions proposed, but to no avail. In the end, I found the problem to have been conditional formatting in the whole of 3 columns (i.e., N:N). Restricting the conditional formatting solved my problem and Excel no longer hangs.
What happens to this topic ? Did you got any response ?
Actually in my case I need to use Excel via the interop library. Am I doomed for this now or do you know if microsoft is fixing this issue also for the interop dll ?
Best regards
Please send me any help you can. Am very frustrated with the appalling performance of Excel 2016 on my Mac.
Constantine
Probably right, a scary thought though.