Microsoft Excel is a powerful program. So powerful, that it’s probably the most susceptible to have problems. I have troubleshot problems with Excel freezing and saying “Not Responding” in Windows. The reasons this happen can vary greatly. Here are the most common ways to fix the problem.
First, check to see if Excel is freezing in more than one spreadsheet. If Excel freezes in any file you open, it is likely related to the program itself. If it only happens in one file, you will have to pinpoint what exactly is causing the problem in that file.
Contents
Excel Freezes Every Time Used
If Excel freezes in every file. Try these steps.
Start Excel in Safe Mode
- Close completely out of Excel.
- Hold the Windows Key and press “R” to bring up the Run dialog box.
- Type
excel -safe
then press “Enter“.
If Excel opens with the above steps, it is likely that a plugin or other software is installed that is interfering with the software. Proceed with step 4 to try to fix the issue. If you still experience problems with Excel started in Safe Mode, try the next set of instructions. - Select “File” > “Options“.
- Select “Add-ins“.
- Select “Excel Add-ins” in the “Manage” drop-down menu, then select “Go…“.
- If any items are checked, try unchecking them, then selecting “OK“. This will disable Add-ins that may be causing the freezing.
- Close Excel, then launch it normally to see if that did the trick. If not, repeat steps 3 through 7, only try a different selection in step 6. Go through the list in the drop-down for “COM Add-ins“, “Actions“, and “XML Expansion Packs” and see if disabling items in those selections do the trick.
Reinstall Office
- Right-click the “Start” button, then select “Control Panel“.
- Select “Programs“.
- Select “Uninstall a program“.
- Locate “Microsoft Office” in the list. Right-click it, then choose “Change“.
- Select “Quick Repair“, then click “Repair“.
- Once the repair is complete. Try to launch Excel and see if you have a freezing problem. If the problem persists, try the “Online Repair” option.
Excel Freezes in Only One Spreadsheet
If the problem only occurs when only one spreadsheet file is open, there is something in the file causing the problem. Give these steps a try.
Clear Conditional Formatting
- While you have the problematic file open in Excel, select “Home” > “Conditional Formatting” > “Clear Rules” > “Clear Rules From Entire Sheet“.
- Select any additional tabs at the bottom of the sheet, and repeat step 1 on each of them.
- Select “File” > “Save as” and make a new copy of the spreadsheet with a different name. The old one will exist if you need to revert to it due to lost data.
If you no longer experience freezing or slowness problems in the file, you will need to narrow down which section is causing the problem and reapply the conditional formatting.
Remove Styles
Download Remove Styles, then run the file. A button wlll then be available under the “Home” tab that says “Remove Styles“. Select it, and see if things speed up a bit.
Clear Objects (Shapes)
Be careful with this solution if you wish to keep objects.
- Hold CTRL and press “G” to bring up the “Go To” box.
- Select the “Special…” button.
- From the “Go To Special” screen, select “Objects“, then select “OK“.
- Press “Delete“.
Thanks to PeterS for this solution.
Thank you for the concise, constructive, correct information to help me fix my computer problem: “Can’t close Excel sheets. No more new fonts may be applied. Please close some other documents and try again.” Computer beeps, nothing happens. I took your advice step by step and I am up and running back in business within minutes.
CTRL + G go to objects ! Excel was lagging dramatically… the sulotuion worked well, though it took severaminutes to delete them… thanks… had no idea what was going on… so surprised someome put thousands of tiny obects into the spreadsheet.. cannot believe it was done by someone intentionally.. would rather blame MS ;) of course MS and their new features… :P
Excel opens slowly and constantly freezes and doesn’t respond. It takes a long time to move between cells. My cursor doesn’t even land within cells as it used to. I repaired, reinstalled Microsoft 365, checked add-ins, etc. The program is completely worthless even with a new/blank spreadsheet. I have no issues with any of my other Microsoft 365 applications.
I’m so frustrated with excel, its been about a week not working because it is extremely slow, freezing taking more than a minute to move to another cell. I have tried the recommended steps suggested online like removing add-inns but there’s no difference, all the spreadsheet do the same thing
What a nightmare! Excel 2013 on Windows 10. Tested everything.
Final solution:
Clear object shapes worked for me (had a lot of boxes generated when clicked outside of cell, I supposed it was deleted)
**Edit: there is a more sophisticated workaround to network connectivity-related hangs here:
https://docs.microsoft.com/en-us/office/troubleshoot/performance/office-slow-or-stop-responding
Add one more solution: turn off AutoSave.
I had no problems with Excel until I moved my desk farther from the WiFi router, then Excel would usually be frozen when I activated the window. Turning off AutoSave works – the reason might have something to do with Windows or Office looking for an open connection to OneDrive so that it can update the workbook in real time.
AT LAST! Finally sorted my headache!
This is what helped:
1. Clear conditional formatting
2. Clear cell styles
3. Change default printer (mine was Adobe). Funny enough, have noticed my Adobe slows a lot of other things down too.
Hello to normal work speed!
Thank you all!
I have typed in 10 cells. No objects, no conditional formats – nothing except typing. And Excel has frozen – again!!! Can anyone suggest a fix in layman’s terms please? This happens almost every time I use Excel.
IN EXCEL SPREAD SHEET WHILE MOVING ROLLER OF MOUSE AT THE SAME TIME ANY POP UP IS COMING
SHEET IS SPLITTING INTO TWO LEAVING WHITE SCREEN IN BETWEEN. ARE THERE SOLUTIONS FOR THIS TYPE OF PROBLEMS IN EXCEL WITH VB ENABLED.
I spent 3 days trying to figure this out, employing nearly all of the various fixes, formatting, resetting the software defaults, etc. I tried on 3 different computers, one with twice the processing speed and memory (it actually ran worse on that machine). It was taking 20-30 seconds to sort, and very time consuming to copy/paste with the “Not Responding” message making it virtually unusable. I then opened a new sheet (destination) and copied one column at a time from the source worksheet and then testing performance as I went along. I got to Col Z, in the source worksheet and the “Not Responding” message popped every time I tried to copy and paste it. The column contained simple text a name. I moved the cursor down the column and noticed a number of empty ?object? or ?comment? boxes that appeared within the right side of the cell. These were scattered throughout the column. How they got there, I haven’t a clue. Once these were removed, the worksheet ran like lightening.
Repairing MS office 365 worked! The weird thing for me was this only locked up one simple small file with a super simple pivot table –
All other spread sheets worked – but none of them had pivot tables.
removing conditional formatting helped
Very unhappy with excel. Very slow and keeps freezing. Why can’t a big company like Microsoft sort their software out so it works with speed.
Hello all
Old legacy spreadsheets can collect Custom Formats in their thousands and this can make a spreadsheets grind to a halt. You can see them under Styles on the Home tab and they are a quick way to format cells.
The problem it seems, is that styles which come in with a copied worksheet are not deleted if the worksheet is and this is how they accumulate. I have seen spreadsheets with up to 10,000 different styles and deleting them refreshed the spreadsheet and brought it back to life.
Search the net for code.
Regards
Greg
Thank you so much. I am an EXCEL Power User for over 25 years!
The “Clear Conditional Formatting from entire sheet for each tab” – worked perfectly for me. I’ve been frustrated for weeks at this.
Please note that when using that option, EXCEL may look like it hangs / freezes while it clears the format, so give it a bit of time one last time) :-) Thank you!
How MS could release such a garbage? It is freezing suddenly after a click on, of focus on, or whatever. Even after several generations such an unstable application, “Reinstall it”, “Reinstall Windows” – very very “professional” solution variants. I can hope only that they are not involved in any airplane targeted software and won’t be ever …
Deleting objects really work. Thank you so much! I was so annoyed by this problem for years!!!!
As well as trying to clear the rules for conditional formatting in a single cell, I’ve also tried the format painter to copy a cell with no conditional formatting as well as copying a blank cell as well as paste special format to overwrite the cell with duplicate conditional formatting. While these may work on some cells sometimes, they run for hours on other cells without ever finishing. I just get Excel not responding continuously and eventually have to end the task in Task Manager.
Someone might suggest restoring an earlier version, but my spreadsheet has been 4 years in the making and is incredibly complex involving thousands of hours in development. Recovering an earlier version where I can undo the conditional formatting problem would sacrifice hundreds of hours of creative work that would be very difficult to replicate.
I definitely have the duplicated rules problem with conditional formatting – many cells have hundreds of duplicates. My problem is clearing the rules is taking far too long. Trying to clear the sheet doesn’t work. Trying to clear 5 cells was still going after 10 hours and I keep having to end the Excel task to try again. I am down to clearing the rules from 1 cell at a time, but even this is taking 20 minutes to more than an hour for each cell and I have hundreds of cells to check and clear. Does anyone know of a quicker way?
Oh my god, this works for me! Tries so many ways to fix thi, and the printer setting was the solution.
____
Excel Freezes in Only One Spreadsheet
Soulition
The Above did notwork for me but If you change the default printer then it worked form me .
All you need is to change the default printer to some other printer from device and printer.
Thank you!! The conditional formatting clearing helped me. It was taking forever to update even one cell in my employee schedules. Took me 4 hours to do the schedule today.
Something to note when I selected ‘clear all formatting’ it took nearly TWENTY MINUTES of waiting until it was complete. So be patient, it’s worth it in the end.
Deleting all the objects was a life saver. Thanks!!
the delete of objects helped me! now i can continue to work with no delays. many thanks! :)
I took PeterS’s suggestion and cleared objects. This was data file and i have NO idea how the objects landed in my worksheet. It took a minute, but the worksheet is clean and no objects found.
Turned out to be a printer issue for me, too. Deleted it in Control Panel and reloaded the software. No more hanging up in that Excel spreadsheet.
Excel Freezes in Only One Spreadsheet
Soulition
The Above did notwork for me but If you change the default printer then it worked form me .
All you need is to change the default printer to some other printer from device and printer.
I know its uncanny but it does work.
this helps to unfreeze my file but I am needed a conditional format to show me duplicates and every time i put it back on it strts freezing again.
There’s another one I just discovered: links to other files. If you break links you might have accidentally created, you can stop some heavy lag.
This worked awesome!!!! Without your help my spreadsheet at work was ruined by day shift!!! Cant thank you enough!!!
Nothing works in my case. The workbook freezes at 80% but ONLY IN MS Surface.
In all other computers – laptops and desktops – opens without problems.
The “Clear Conditional Formatting” – worked perfectly for me … I’ve been frustrated and p’ off for weeks at this. (however the computer may hang / freeze when you do this you just have to wait it out one last time) :-) Thank you!!!
It worked for me as well. Thank you very much.
THANK YOU!! For YEARS I had a file that would not respond for 1-2 minutes periodically while working on the sheet. Sometimes it would only allow me one click before “not responding”. This was extremely frustrating. I tried everything from removing add-ins, conditionally formatting, and reinstalling the program. NOTHING worked. Finally found this help site that suggested by PeterS to remove objects. OMG!! finally a solution to my frustrating problem Thank you PeterS and techipages for sharing this. I probably would have a broken computer (LMAO) if I didn’t find this solution.
Thanks for these suggestions :
My Problems was : Excel Freezes in Only One Spreadsheet
i tried the both steps and the problem solve.
My work excel file is DATABASE of 9000++ contacts so its getting extermely difficult & annoying coz its always very slow & there are some symbols appearing on the sheet in a few cells. I did all the troubleshooting mentioned but no help!
Thanks Mitch for this help. Testing it this arvo and hoping it rids me of the pain long enough to complete my analysis! I’ve donated to Jamie’s fund. <3 goes out to her and all affected. Thanks for being so generous of spirit.
Just used the tip to remove all the conditional formatting and it worked a treat.
Thanks
It worked for me as well. Thank you very much.
…Great…its worked and helped me a lot….thank you very much….
Great post! Worked perfectly! Thank you!
Yes, it worked! Did the safe mode instructions you suggested. I then went back into my excel invoices and was able to see whole page and could edit. Fingers crossed. I have Windows 10. On a Samsung laptop. Thank you!
yey! it works for me. my excel works fine now when i disable the conditional formatting i can now encode smoothly with out excel freezing. thanks to this:)
Helped. Thanks very much for this very good posting!
Excel is a two dimensional database.
the more you put into it, the slower it gets.
If on Windows 10,
I’ve had better luck downgrading to Office 2013 compared to using 2016
I, along with hundreds of people I’ve found on the internet recently, are plagued by extremely slow processing times within Excel 2016. I am looking everywhere for help. Hopefully you can provide some insight.
I work within very large data sets/cubes, so processing time was already a bit of an annoyance when using 2013, but since I switched to 365/2016 last week it has been unbearable. My productivity has sunk drastically, as I now sometimes spend ~20-30 minutes waiting for a single pivot field to populate <1000 rows.
I have always had a penchant for Microsoft, but as an analyst I just cannot find this to be acceptable.
The only thing I've found that some people have had luck with is simply removing all filters before running calculations. Some people even go as far as disabling auto-calculation whenever they want to make an additional change to their file. Both of these are highly inconvenient, time-consuming, & unsustainable workarounds. And as for me, I would not even consider them to be an option while working in our larger data cubes.
Notes: My system is clean & performs extremely well in all aspects outside of Excel 2016 (HP EliteBook, i5, 64 bit, 16gb ram, ample local storage remaining, etc.). I rarely use conditional formatting, unless absolutely called-for. I have no add-ons active. I have no viruses affecting processing speeds. I truly don't believe the issue is stemming from my machine, but Excel 2016.
Please help in any way you can.
Clearing Conditional Formatting (Home, Conditional Formatting, Clear Rules) fixed the issue for me as well
I don’t know how a Conditional Format haf been set, as I have never used CF
Didn’t help. The file opens fine on desktop iMac (running Windows) and on laptop Toshiba ultrabook.
It freezes on Surface, reason why I have to assume that the problem is hardware related. A big disappointment as I bought the Surface to replace the Toshiba and it is much worse.
Great tips :-) I had a small spreadsheet (< 1MB) that was slow even if saved on local drive. Removing conditional formatting solved the problem.
Thank you good info
As many others have said already, removing formats (including conditional formatting) solved the problem in my 2.9Gb workbook. The interesting thing was that I removed them only from the first worksheet (intending to work through all the 20 or so worksheets in turn) and that solved the problem. I then tried restoring a couple of the conditional formatting schemes which involved columns up to AH and rows down to 1200 and there was no issue. The workbook now functions as quickly as it ever did (that is, instantaneous), even though there is lots of conditional formatting and other formatting in the other worksheets.
Sorry to be so gabby!
Thanks a Lot i was mad why excel was delaying. Thank you Sir for your useful suggestion
Changing the default printer worked for me. I was unable to right-click format cells prior to changing from my network printer to a .pdf writer instead. As soon as I did that, my Excel issues were fixed. Put it back to my network printer and it stopped responding again.
You are amazing. Thank you so much!! I think it was the objects that did it for me!! Cut my file by 90%
Hi all,
First of all I checked that my problem had to do with a specific worksheet. Having found out that, I cleared all conditional formatting from the whole sheet and then I re-inserted it but only to the cells that I needed the conditional formatting to apply. After that I had no problem! Keep in mind to do that at some points in time for all conditional formatting that you have applied, especially if the sheet is a live one and data are often inserted and deleted in that sheet.
Great advice! Thanks a lot.
/Agis
Hi all,
Conditional formatting was my problem too. I removed all and re-inserted the formatting but only in the cells that i needed it to be in; previously I selected the whole column.
Thanks for the great advice.
John
Finally, a site, a blogger and a solution. So so rare! Searching and moving objects was the key. Thank you so much
Thanks Conditional Formatting was my devil too, Thanks again, it’s working fine now, is there any way to have conditional formating and have it not suck that much, may be lesser cells than the entire sheet?
I got a new computer with better specs than the old one. The same spreadsheet with practically the same conditional formatting worked fine in both computers. Just one day, the file in the new computer was way slow. I removed the cond. formatting and did the trick. I wonder why
at work we have a few PC’s that excel is extreamly slow and crashes with large documents (these are needed) and we have tried everything including fresh install of win 10 and swapping the computer for one with the same spec. nothing seems to fix the problem.
the only solution is to remove the VBA Project (personal.XLSB)
Personal.xlsb is your Personal Macro Workbook containing macros that should be available in all workbooks. It is loaded automatically when Excel is started.
If you really want to remove it:
Quit all instances of Excel.
In Windows Explorer, go to C:\Users\\AppData\Roaming\Microsoft\Excel\XLSTART (AppData is a hidden folder, you must show hidden files and folders in order to see it).
Move Personal.xlsb out of the XLSTART folder
Thank you so much :) , this was really very helpful.
After months of struggling with one spreadsheet that was EXTREEMLY slow, removing conditional formatting solved the problem!
Thanks
I have a spreadsheet I’ve been using for several years to track expenses. I access it everyday and never had any issue with it until a month ago. Then it started “not responding” every time I made a cell entry. Tried copying and pasting “values” only in each column, removed 5 years of data, but nothing helped. Spreadsheet that was never bigger than 400k suddenly starting increasing by 100k every time I added a few cells.
Considered downgrading to Office 2013 then read this article. Once I deleted objects that I didn’t know I had it reduced the size from 1.3M to 380k. Thanks so much for the fix!
MITCH thanks very much for posting this!! Very helpful
Many thanks!! Removing conditional formatting from my Excel spreadsheets resolved the slowness issue. Microsoft should improve it…
I have a large file that has conditional formatting applied to two columns, and I want to filter for the highlighted duplicate columns, so I can copy just those rows to another workbook. When I click on the filter arrow, this is when Excel becomes unresponsive. If I wait long enough, it will usually give me the box to choose what filter to apply. but it’s not guaranteed to work.
I wondered if it could be my computer. I only have 4 GB of memory.
THANK YOU! Horrendous problem with extremely slow spreadsheet fixed by clearing objects!!! Excel 2016 spreadsheet with monthly updates over many years. I don’t think I use objects, but evidently one got replicated many times when I drag cells to duplicate contents. I followed the directions above explicitly and it took about ten minutes to delete all objects (that I didn’t know I had in the spreadsheet!).
Finally found a solution to fix excel. Clearing the conditional formatting was the trick. Much appreciated.
Well, just don’t use fancy stuff you don’t need really.
I have same issues and every solution I saw on the net seems to say is “Do not use any fancy stuff available in Excel” that does not bode well for the software.