Excel freezing for no reason

%3CLINGO-SUB%20id%3D%22lingo-sub-1936732%22%20slang%3D%22en-US%22%3EExcel%20freezing%20for%20no%20reason%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936732%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20I%20know%2C%20the%20subject%20is%20common%2C%20but%20unfortunately%2C%20even%20reading%20every%20discussion%20and%20solution%2C%20Excel%20is%20still%20freezing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%2C%20I%20work%20in%20an%20offline%20market%2C%20where%20I%20generate%20huge%20spreadsheets%20with%20data%20(txt)%20and%20basic%20cell%20formatting%2C%20with%20a%20menu%20with%20hyperlinks%20that%20I%20pull.%20The%20table%20never%20exceeds%20800KB%2C%20however%2C%20sometimes%2C%20even%20without%20any%20external%20data%20connection%2C%20without%20formulas%2C%20when%20I%20copy%20(or%20any%20of%20the%20vendors%20or%20customers)%2C%20the%20table%20freezes%2C%20and%20paralyzes%20all%20other%20Excel%20files.%3C%2FP%3E%3CP%3EHow%20do%20I%20solve%20this%3F%20I%20don't%20solve%20it%2C%20I%20copy%20a%20random%20file%20from%20my%20computer%2C%20and%20that%20makes%20it%20cancel%20the%20action%20in%20excel%2C%20and%20unlock%20it.%3C%2FP%3E%3CP%3EI%20have%20already%20applied%20all%20possible%20usability%20solutions%2C%20but%20the%20error%20persists!%20This%20is%20already%20driving%20me%20crazy.%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20idea%20what%20the%20solution%20to%20this%20may%20be%3F%20(making%20tables%20smaller%20and%20without%20usability%20is%20out%20of%20the%20question).%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EMy%20office%20Microsoft%20365%3C%2FP%3E%3CP%3E***The%20attached%20file%20cannot%20be%20used%2C%20reused%2C%20or%20shared%2C%20and%20serves%20only%20as%20a%20functionality%20experiment.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1936732%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1936883%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20freezing%20for%20no%20reason%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936883%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883808%22%20target%3D%22_blank%22%3E%40renankzz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EFirst%20of%20all%2C%20here%20is%20some%20information%20that%20you%20can%20go%20through.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20will%20look%20through%20your%20file%20later%20and%20also%20inform%20you%20about%20it%2C%20as%20far%20as%20I%20can.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20not%20responding%2C%20hangs%2C%20freezes%20or%20stops%20working%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fexcel-not-responding-hangs-freezes-or-stops-working-37e7d3c9-9e84-40bf-a805-4ca6853a1ff4%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fexcel-not-responding-hangs-freezes-or-stops-working-37e7d3c9-9e84-40bf-a805-4ca6853a1ff4%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello! 

 

Yes I know, the subject is common, but unfortunately, even reading every discussion and solution, Excel is still freezing.

 

Well, I work in an offline market, where I generate huge spreadsheets with data (txt) and basic cell formatting, with a menu with hyperlinks that I pull. The table never exceeds 800KB, however, sometimes, even without any external data connection, without formulas, when I copy (or any of the vendors or customers), the table freezes, and paralyzes all other Excel files.

How do I solve this? I don't solve it, I copy a random file from my computer, and that makes it cancel the action in excel, and unlock it.

I have already applied all possible usability solutions, but the error persists! This is already driving me crazy.

Does anyone have any idea what the solution to this may be? (making tables smaller and without usability is out of the question).


My office Microsoft 365

***The attached file cannot be used, reused, or shared, and serves only as a functionality experiment.

4 Replies

@renankzz 

First of all, here is some information that you can also go through. I will look through your file later and also inform you about it, as far as I can.

 

Excel not responding, hangs, freezes or stops working

https://support.microsoft.com/en-us/office/excel-not-responding-hangs-freezes-or-stops-working-37e7d...

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@renankzz 

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.

@Nikolino 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.