Dec 20 2022 04:35 AM - edited Dec 20 2022 04:56 AM
Strange one; I can be working on a spreadsheet (on a laptop using Excel and not the web version) and it will no longer let me click into a cell or enter data etc. The only two ways to 'unfreeze' are to move to another open spreadsheet, save that one and then revert back to the one that was not accepting any actions, or close the spreadsheet and reopen.
Any thoughts oh wise ones?
Dec 20 2022 05:17 AM
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.
Dec 20 2022 05:31 AM
Dec 20 2022 10:14 AM
Dec 21 2022 01:45 AM
If 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.