If I restore the window, the lag decreases. Do you enjoy the latest version of Microsoft Office yet? Repair your Office programs Repairing your Office programs can resolve issues with Excel not responding, hanging or freezing by automatically repairing errors in Office files. If your issue is not resolved after you test it outside the third-party application, continue on to the next item on the list. If your issue is resolved after you run Excel in safe mode, see:. This will allow you to figure out which add-in is causing the problem. Turning off editing in cells doesn't help very much, yes you can use the formula bar but as I said in my post on the 14th, sometimes if the formula is too big, you can't read this and it locks up.
Has anyone come up with any solution since this post was first noted? Support for reading charts in Microsoft Excel. But if you have a slow computer you might find the animation annoying because all it will do for you is slow down the working process in the program. The registry values seem to have changed at some point. Has anyone seen it before? However, if they manually open the application and then pull up the file from the Open or Recent Documents window, there's no lag whatsoever. All around the web the first 2 solutions are suggested. Hi all, So I have been reading your comments, and I just had this issue with in the past week at my job.
For instructions on doing this, see:. Deleting the comment Move to the cell with the comment, A21 in the originally linked workbook, press the context menu and press M for delete comment does speed things up. The only way to fix this seems to alt tab out of the excel window and then back in again before it starts reading the cells, all be it very slowly. If it's Microsoft, can we ask them kindly not to do this? I fear that I may have to use another spreadsheet application if this is not resolved. Is there anything at all we can do to keep them fairly constant? I have to alt tab back out and into the application again. However, forgive me, your post doesn't mention how any of this is to be resolved.
I have seen this issue on many different types of coputer. Has anyone else found this? If these steps do not resolve your issue, continue on to the next item on the list. Reply to this email directly, view it on GitHub, or mute the thread. Also, closing all excel files does the trick. And the issue is seeming to get worse and worse.
Sometimes it can take up to 2 seconds to move between cells. Check to see if your antivirus software is up-to-date or conflicting with Excel If your antivirus software is not up-to-date, Excel may not function properly. Oddly, the delay does not happen when I do a regular paste and then use the drop-down menu that appears in the file immediately after the paste to select paste values--it is only when I use the paste values command underneath the paste button in the top ribbon. Our office just upgraded to Win10 and this issue started after that. Ask the community Get help from experts in our forums: for personal, home, or university users for business users Provide feedback in Office app You can send feedback directly to our Office teams:.
Usually happens when I open 2 documents or more. If i disable hardware acceleration in word it gets about 75% better but not fixed. 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. For example, a user will open a spreadsheet and click on a cell to view a formula and it takes forever to get a response. Why would the experience differ between Windows 10 users? They perform the task to completion, but data-entry is pointless.
The protocol that stopped the problem for a while was to disable add ins and then re-enable them. The comment is on cell A21. Frequently, a user inherits an Excel file but doesn't know what is included in the file. Just looking at this issue again, yes the issue is still present in Excel 365 as at 15 October 2018. The slowdown is twofold - when you press say down arrow, the border around the current cell moves down.
I'm using Win 10 now, it took me a while to find this. I did the Excel - turn off hardware accelerations, then used the Windows-U trick. If the issue does not occur when you restart Excel, start enabling your add-ins one at a time until does. Ever since my business upgraded to Windows 10, we have been having weird issues where Excel freezes unexpectedly. You can reproduce this by changing the mouse frequency in the mouse drivers from e. It pointed to the User Guide so I pressed enter 3. This has been an issue for months on many computers.
I am happy to assist in any way I can with testing etc. Since installing it, I have encountered an issue unique to Excel in which the framerate in the spreadsheet window drops significantly. Many people at work put comments into Excel and I can't very well ask them to stop doing that. Is this only program that is running slow or is it the only one that the users are mentioning having the issue? For system requirements of the Microsoft Office suites, go to the following Microsoft articles: Office 2010 introduced native 64-bit versions of Office products to take advantage of larger processing capacities. It doesn't affect other programs or Office applications and helps to disable animation with a few mouse clicks. In this case, the files may be generated incorrectly, and some features may not work properly when you open the files in Excel. Disabling screen updating while making all the object model calls I.