Excel 2007 Random Crashes and/or Hangs

Excel 2007 randomly crashes and/or hangs.

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

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

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.