Forum Discussion
Excel freezes till I save another worksheet
If I may recommend, describe exactly (step by step) when and how the problem arises.
Informing about your Excel version, operating system, storage medium and Excel file type, it would be a great advantage to get a more accurate solution.
Nevertheless, I found you this link with different solutions.
Please make sure to do an update in advance.
Excel not responding, hangs, freezes or stops working
This link discusses troubleshooting steps that can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open an Excel workbook. These types of problems may occur for one or more of the reasons listed below.
Follow the solutions provided in this link in order. If you have previously tried one of these methods, and it did not help, please go to the next solution in the list.
- Thanks NikolinoDE - good point, well made!
Surface 4 laptop, windows 11, using laptop disk storage.
current version of Excel on the laptop -= Microsoft® Excel® for Microsoft 365 MSO (Version 2209 Build 16.0.15629.20256) 64-bit
Typically have 2-6 spreadsheets open and working, can be many more - never been an issue in all my years
when using Excel over the past couple of months, it would periodivcally hang. Literally I could be doing data entry, reformatting, copy & paste, any normal task and it would just stop allowing any action with the cells. I can save the sheet.
at this point I can either close and re-open or I can flip to one of the other open sheets and save it, anyone is fine. I go back to the sheet that was hung and can now continue.
one theory was that it could be to do with data links, none are there in any open sheets now. another theory was printing to file, that is disabled.
there are no macros on any of the sheets, they are all XLSX files.
software is all up todate, and computer restarted oftenIf I may add, that might help without a guarantee.
Run a repair if that doesn't help Start Excel in Safe Mode and disable all AddIns.
Then close Excel and start it normally. If the error has been corrected, then switch on the AddIns again individually to see where the error is coming from.
If that doesn't help either, you could try disabling the virus software and then try.
Sometimes problems occur in excel caused by third party software.
If none of this helps, then the last step is to uninstall and reinstall Office.
Nevertheless, I hope that one of these suggested solutions will help you.
