Forum Discussion
Excel freezing for no reason
After a few minutes of clicking around and doing calculations on the file, I couldn't replicate the problem on myself. I tried it in Office 2016.
Microsoft Excel is by far the most widely used spreadsheet for Windows and almost always works smoothly. Sometimes it happens, however, that Excel freezes when it starts or suddenly stops responding when opening a file. Often the problem is not caused by Excel itself, but by additionally installed add-ins or macros or software installed afterwards. Virus scanners and Windows updates are also known sources of error. However, an incorrectly saved Excel table can also cause Excel to hang.
The following solution strategies usually lead to success if Excel does not work as desired.
Start Excel in Safe Mode
Turn off add-ins
Virus scanner problems
Problems with other programs that use Excel
Change the Windows default printer
Repair Microsoft Office
Recompile macros
Update Excel
Try out Microsoft Office Repair from the Control Panel beforehand, then check for updates and then scour the other options.
Thank you for your understanding and patience
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
NikolinoDE First of all, thank you so much for your response. I'll be trying those steps, and reply again to you, to solve this trend.
But thanks again for your precious time dedicated to my problem!
- I bought XL 2016. It is not the 360 version or any pay as you go monthly subscription version.
I have my computer set to automatic updates which seems to be constantly updating. I think it seems to update and restart every week.
It has had the bug that causes it to freeze for no reason since Day1. Your problem is not likely because of the complexity of your interactions with data feeds or the other factors you describe. If you open a new simple workbook, just type data from page to page, eventually it will just freeze. It will not give you a not responding error, or crash. It simply will not add a character as you try to type.
Here is a "solution" if you can call it that: when it freezes, click on the "+" Tab to add another sheet to the workbook. Randomly click on a call (yes it always allows me to add a sheet and the cursor and typing will be active in this new sheet). Pick a random cell on the new sheet and type a few random characters in a cell - it can just be gibberish. Then return to the sheet from which you came by changing Tabs (yes it always allows me to do change back to the original sheet). Then continue as if nothing happened and it will allows you to type or do whatever you were doing before it froze. NOTE: when you click to return to your original sheet upon which you were working it may do one of two things: One, it might just continue as normal. Two, if you have another XL workbook open on the computer, the first action you take when you return to the original worksheet may cause the other open workbook to pop to the top of your desktop as if you clicked on that second XL app that you have open on the computer in the background. If this happens you simply minimize it and you will be working back on the sheet that originally froze in the other workbook. This 100% all the time works for me.
XL2016 is just buggy and that is all.
FYI: I work in a laptop not a network. I don't link to external data feeds. I don't take in many spreadsheets from others; I mainly create 99% of the spreadsheets on which I work. I'm in Windows 10 and I have a HP gaming computer with plenty of RAM (but I have zero games on it and it has never been used to game. I don't have any antivirus from third parties but rather rely on Windows security. (I do have a free SuperAntiSpyware but not a version that allows you to integrate apps. It is more of a version that you can periodically scan for problems and clean out cookies). I do always have Chrome / Excel / Word / Windows Explorer / PdfPro open in multiple incidents with many files and many Tabs active in each - especially many incidents of Chrome all having many many tabs in each incident. And my excel sheets do have many formulas, pasted pictures, formatting, and sometimes Design Forms from the Developer Tab in XL e.g. check boxes, voting boxes, drop down lists. I do not have any other apps that freeze, crash, or cause other incidents of themselves to pop forward on my desktop.
I hope this helps you as a fix not a solution for you. The real solution to freezing needs to come from MSFT who created this buggy version. I have been using XL since before 2000 and have never had such problems as freezing ever before this 2016 version.
