Does the spreadsheet have external links to network data sources? The interesting thing was that I removed them only from the first worksheet intending to work through all the 20 or so worksheets in turn and that solved the problem. It's everyone's favorite home page! Jaws is far less sesseptible, somehow. I suspect this is a registration connection issue. Draft mode does help but I don't always want that, esp. Incidentely I just have it reading cell coordinates, not boarders or other information beyond the text in the cells.
If I open an Office App by itself, and no other Office App is running, it takes approx. In 2013 macros running fine originally created in office 365 2013 finishing in 10 minutes, in 2016 not finished even after 45 minutes. After rereading this thread and some other threads, I tried the suggestion of logging out of my Microsoft account and since then every file has been opening with no delay. Starting Tuesday, February 23, end users will be able to download the new applications from their own pages on the Office 365 website accessed with their corporate usernames and passwords. I hope someone can clarify what changed and how to correct the issue. Anyway, I just needed to vent. I have no idea how so many copies of the object ended up in there as I only inserted it once.
In the case of my laptop using wireless — disabling my wireless connection meant it was not connected any more, and with no internet connection excel opens near instantly — in contrast to waiting for timeouts on license checks with partial connectivity. These are odd times in our Windows technology world. I am not an expert on this field, but had a similar issue even with older Office versions. I was wondering if it was a mac issues, but I guess not. Excel and Word now open much faster. Follow me on , or visit my. This morning a truck snapped the optical fiber cable that provides internet to the office and I was really mad that I couldn't work on some documents because I didn't have internet.
Mine is the same and it's very annoying - all my work is report writing and it's a nuisance. The machine that was having this issue is brand new, narrowed it down to the application Waves MaxAudio Service that was enabled in startup. The Mac Excel 2011 has the no-screen-updating built in but doesn't blank out the screens -- it just didn't update anything until it is done with the macros. And as for me, I would not even consider them to be an option while working in our larger data cubes. My build number is: 16. Then there is the time between that and the contents of the newly focussed cell being read out, another two seconds. Now though, as I noted above, there's improvement in the loading speed.
The old one will exist if you need to revert to it due to lost data. There are a number of troubleshooting tips that apparently work for some people. I rarely use conditional formatting, unless absolutely called-for. If I open Excel first, then the file — no problem. Any help you could offer would be most appreciated and I am happy to try things to help. Now everything opens in 5 second flat. That doesn't mean some fine tuning on Microsoft's part couldn't help a lot, but that's what I'm guessing.
Thx for all the ideas. I am going to have to re-think how to solve this. Anyway, this fixed my problem, hopefully it will do the same for you. Because after that the apps open at the same speed as the native Apple apps. It seems to me we have a lot of issues building up in Excel that make it very hard or frustrating to use especially in an office environment, with no clear resolution path. There does still seem to be some slowdown if the window is not maximised but not as much as when the window is maximised say 1 second to start reading a cell rather than 3. Hi Quentin, thanks for the confirmation that these issues are still present.
Subsequent execution becomes very slow. For instance, I am a college professor and require my students to use Word so I can comment in their papers, even though I've tried everything to find an alternative. The corner of a cell with comments is coloured red in the same way a cell with a different formula to surround cells has the top left coloured green. I have recently upgraded to 2016 It did not start happening immediately after the upgrade; just in the last few days. I agree running a repair is a good idea at this stage. If it helps, I've done some more investigation and it does appear that the thing that really really slows down Excel is special cells, i. If not, repeat steps 3 through 7, only try a different selection in step 6.
Is it configured to run any sort of data update query at open? Clear Objects Shapes Be careful with this solution if you wish to keep objects. Incidentely I just have it reading cell coordinates, not boarders or other information beyond the text in the cells. The first time the user opens a sheet it opens fast, but after about 2 or 3 sheets, it can take up to 10 seconds before Excel opens the sheet. I truly don't believe the issue is stemming from my machine, but Excel 2016. I have a problem where I'm typing in a table in Powerpoint and come to the end of the line - naturally powerpoint should just continue my sentence on the next line but it seems to be highlighting the whole cell text and then as I am typing faster, it is overriding the cell text.