Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Excel 2007 Random Crashes and/or Hangs


View products that this article applies to.

Symptoms

Excel 2007 randomly crashes and/or hangs.

↑ Back to the top


Cause

This is due to Com Addins that were built for XL2003, being loaded into XL2007, and
not being Compatible.

The most common is the Adobe PDF Maker

↑ Back to the top


Resolution

Look for addins or Com Addins.

For Addins:
Start Excel, do an Alt-F11, which will take you to the VBA Editor Window.
Do a CTRL-R which will take you to Project Explorer.
In Project Explorer, there should be only one Progect (Book 1).
If there are additional projects, we will need to remove them.

Go back to Excel, and select the Office Button | Excel Options | Addins | Manage
Excel Addins | Go and unselect all addins that are checked.
While in Excel Options, Select Advanced | General | �At Startup open all files in �
and make sure this box is blank.

Go to C:\Program Files\Microsoft Office\Office 12\XLStart and remove any files in
this directory
Go to C:\Documents and Settings\<user name>\Application
Data\Microsoft\Excel\XLStart and remove any files in this directory.

Close then Restart Excel, the Project Explorer in the VBA Editor should have only
one Project, Book 1.

For Com Addins:

Start | Run | Regedit | Enter

If Excel is not under the Office Key, there are no Com Addins.

HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins and see how many addins
are there.
Select each addin, and in the Right Window, select LoadBehavior.
Right Click on LoadBehavior | Modify | and set it to zero (0). The normal setting
is 3.

HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins and see how many addins
there are.
Set each addisn�s LoadBehavior to zero (0).

If this is a 64 bit machine, look for addins at :
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\Addins

↑ Back to the top


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

↑ Back to the top


Keywords: KB2012541

↑ Back to the top

Article Info
Article ID : 2012541
Revision : 1
Created on : 6/10/2010
Published on : 6/10/2010
Exists online : False
Views : 174