Constant Freezing and Crashing
Our take
Hi everyone,
Trying to troubleshoot a strange Excel issue affecting a number of users in our environment and I’m curious if anyone else has seen something similar.
Users report that Excel will lock up when switching between applications or when copying between Excel workbooks. The freeze can last around 10–30 seconds, after which Excel either recovers or occasionally crashes completely. If excel recovers for several more seconds clicking a cell sometimes selects the wrong cell or highlights an entire range instead of the single cell that was clicked. For example, the user clicks one cell but Excel highlights several cells nearby. Maybe an issue with DPI scaling issues?
Some environment details:
- Microsoft Excel (Microsoft 365 Apps for Enterprise)
- Monthly Enterprise Channel
- Most affected machines running version 16.0.19530.20226
- Some users on 16.0.19426.20260
- Mix of Windows 10 and Windows 11
The issue appears across different machines and hardware, including multiple laptop brands and models with both lower and higher specs, so it doesn’t seem to be related to performance.
It also doesn’t appear tied to workbook size as the issue happens with both small spreadsheets and larger ones. Resources look normal when the freeze occurs.
Typical triggers seem to be:
- copying between Excel workbooks
- switching between Excel and another application (browser, Outlook, etc.)
- returning focus back to Excel
Files are opened from a mix of locations:
- OneDrive
- SharePoint
- OneDrive SharePoint sync folders
- local files
Users are working on laptops connected to external monitors, usually with the laptop screen still open as well. Some setups do have mixed display scaling (e.g. laptop at 150% and monitor at 100%) which could be causing the crashes?
Things we’ve already tried:
- disabling hardware graphics acceleration
- disabling Live Preview
- disabling background error checking
- setting Excel to power saving GPU mode in Windows graphics settings
- testing across different machines and workbooks
The issue appears specific to Excel, since other applications on the same machines don’t show similar freezing or input issues.
Has anyone run into something similar with recent Microsoft 365 builds or seen Excel behave like this when switching between apps? Any suggestions for additional things to test would be really helpful. I am loosing my mind.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 'Research' freezes my Excel 16Alt + Left click is a shortcut for research in Excel 16, and it is causing an annoying problem for me. When I open any excel workbook and "Alt + Left click on a cell for the first time", my excel stops working for roughly 3 minutes. It happens even on an empty sheet. After 3 minutes, Excel eventually works. Alt + clicking on a cell does not freeze Excel anymore. But the problem is not gone. Normally, moving from a cell to another by clicking should take zero time. But, when I click on a cell and then alt + click on another, the cursor stutters for a split second like running a game on a computer that fails to meet the requirements. I asked AIs to fix the problem but they failed equally. Things I tried: Disabling Research through VBA. - I ran a code on the immediate panel(the thing that Ctrl + G opens). The code looks like : "Application.CommandBars("Research").Enabled = False" - I don't like it because its only temporary. - Most importantly, the 3 minute freeze is still there. (I really hope to know why) Disabling Hardware Acceleration - It didnt work. Resetting Microsoft Office Applications through Windows Setting. - Even this didnt work. Disabling Add ins. - I dont have any active Add in. Removing Excel file in appdata folder - It didnt work. Could anyone suggest me a thing to try? submitted by /u/asdf9999999999 [link] [comments]
- my excel freeze for even simple things like boldening/italicising cells. why? solution?i have an excel file i maintain. its a small file, not big, a few kb. but sometimes, when formatting cells, say bolding text or italicising, my excel stops responding and freezes. the cells arent links, they just contain bog standard text of one or two words. it doesnt happen all the time, but occasionally. but its still annoying. my own laptop has excel 2021. my work laptop has 365 and sometimes it happens there too, so i think this is some sort of problem with excel generally. has anyone else experienced this and can advise on a solution? thakns submitted by /u/Illustrious_Fig_8537 [link] [comments]
- Excel freezing on new work laptopRecently received a Windows 11 HP I7 G8 with 64gb RAM with a 1 tb hard drive running M365. The old laptop was converted to windows 11 and M365. Smaller hard drive but upgraded ram to 64gb. Old laptop had no problems with PQ or VBA. New laptop freezes just trying remove rows or sometimes just navigating around a simple file. Has anyone else experienced this? FYI: new laptop has had all software and drivers updated. submitted by /u/relic65 [link] [comments]
- Excel crashing while in VR. Any ideas as to why?I have a set of workbooks that are a set of TTRPG rules and character sheets (having all of the sheets in one workbook caused excel to continuously crash). This has been working fine but for no apparent reason a couple of days ago one of the workbooks just started instantly crashing the moment you do anything with it, and even if you don't do anything it'll crash within a few minutes, this then causes all of the open workbooks to freeze. Occasionally it'll go about 10 minutes before it crashes, but that is rare. Every time it crashes however it says the workbook is saving, which seems to be true since after you end task on it all of your changes seem to have been saved even up to right before the crash, but it isn't saving. I have left it a whole hour to see if it actually will save and it doesn't. Strangely this behaviour only seems to happen when I am in VR. Outside of VR I can't get the error to occur, at least not yet, but it is guaranteed while I am in VR. I can't think of any reason why this would be. I use the VR so I can have more and larger screens that can be easily moved around, mostly the virtual desktop app for the quest 3, but it also happens when using steamVR to give you multiple windows too. If I am not in VR though the workbook is happy as a clam, no freezes, no crashes, just works fine. I would like a fix as the whole reason for this is to allow me to play with a VR VTT while having a custom ruleset and such floating around me ready to use. There aren't any scripts active on the workbook that causes the freezing, so it isn't to do with scripting as far as I can tell. And at least so far all of the other workbooks work fine, but since I can't tell why this one does not (it is a character sheet and identical to other character sheets). The issue first started to happen after I created a data validation dropbox that looked at another workbook, but i have since tried deleting all of the data validation drop boxes, and highlighting the entire sheet and selecting data validation (which it says will delete all data validation rules even though it doesn't seem to have done). submitted by /u/James_DeSouza [link] [comments]