Nov 27 2020 10:32 AM
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.
Nov 27 2020 11:43 AM
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
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Nov 27 2020 12:13 PM
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.
Nov 27 2020 12:34 PM
@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!
Mar 19 2021 05:33 AM
Jan 09 2022 10:39 PM
Jan 10 2022 01:28 AM
I can very well imagine how annoying it can be if you are prevented from continuing in the middle of your project. I can very well imagine how angry it can make you if you don't have the time for "such nonsense".
Nevertheless, every error correction always takes place after the error has been found.
The error can be varied, just as varied as the possibilities that Excel provides as a spreadsheet.
Therefore, I always ask for patience in advance, even if I know that this is actually not an option in such cases where an error occurs.
If I may recommend ....
Run Inquire to see if some formulas or links have errors.
Even if the updates are set to automatic, please update again manually. Some upgrades are displayed as updates, but it is not always set so that no matter which updates are carried out.
Perform an Office repair immediately after the updates.
The next step would be to start in safe mode and restart immediately afterwards.
If none of this helps either ... the last thing you could do is update the graphic drivers and readjust the monitor analysis. Sometimes the monitor analysis is smaller than that of the graphic map with the result that the graphic map analysis is set very high, but the monitor has problems displaying it. Especially with Excel, where the processor performance is concentrated on the calculations (mostly Excel is set so that all processors concentrate on the calculation), the whole PC can freeze.
If may notice, I've been using Excel 2016 Pro for years with an HP laptop without any previous problems with recognizing the software itself.
With my little Excel experience so far, most of the errors I have seen so far (and there are quite a few) excel is not itself the problem. But that's just my humble experience.
* I am not an employee of Microsoft and have no dependency in any form whatsoever with or on microsoft, am a simple user like you who just wants to help.
Thank you for your patience and time.
I know I don't know anything (Socrates)
Feb 04 2022 02:17 PM
@renankzz I googled this a bit more and prelimnary results was that this forum offers the solution:
https://www.reddit.com/r/excel/comments/b62o09/sometimes_when_i_clear_a_filter_excel_kinda/
I noticed a specific sheet was the worst, so I removed all conditional formatting. Hope it helps!