Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Excel 2007 Locks up Frequently

Posted on 2009-12-28
Medium Priority
Last Modified: 2012-05-08
This question has been asked before here at Experts Exchange, but not resolved (back in January 2009) -- I am having the EXACT same issues.  

All Files are being saved in .xlsx format.   Still locks every time I open an Excel file.   Very Frustrating.  Do a Google Search of:  "Excel 2007 Locks Up" and see  the hundreds of others dealing with this same issue.  Microsoft was NO HELP and they now want $249 to trouble-shoot their their buggy software!   No way.  I'll dump Excel before I pay them to fix their flawed program.  

Any clues on what is cuasing this?   I have a newer i7-920, 4-GB RAM, Windows 7 (32-bit) - ATI Radeon 4770.   System is very fast and very stable -- except for Excel!  

The prior post on this issue here at EE was asked here:  


Thanks for any help!
Question by:BAmiller

Accepted Solution

holthd earned 2000 total points
ID: 26134221
It could be a number of things. Most likely it's not Excel itself but an external issue (external to Excel that is).

*First off, try moving the files to different harddrive. Is it still the same?
*Try opening the same files on another PC running Excel 2007.
*Click on the Home button (big-ass windows logo) > Excel Options (hardly visible...). Now open the Add-Ins tab.
At the bottom it says Manage: <component type> GO
Start at the top and work you way down the list. Deactivate one add-on by time and check if the problem presists.
I'm using Excel 2010 so this is mostly from memory.

Does any these help?
If not, open Event viewer and check the application log. Here I guess you'll find some warnings. See if they corresponds to the time of Excel freezing and post them here.
You can open the Event viewer by going to Start > Run > eventvwr.msc


Author Closing Comment

ID: 31670561
I found four (4) COM Add-ins and I disabled them all, then it fixed the locking issue.  Thanks!  

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question