Excel 2007 Random Crashes and/or Hangs

Symptoms

Excel 2007 randomly crashes and/or hangs.

Resolution

Look for addins or Com Addins.

For Addins:
1. 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.

2. 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.

3. Go to C:\Program Files\Microsoft Office\Office 12\XLStart and remove any files in
this directory
for XP
>Go to C:\Documents and Settings\<user name>\Application
Data\Microsoft\Excel\XLStart  and remove any files in this directory.
for Windows 7 
C:\Users\<user name>\AppData\Roaming\Microsoft\Excel\XLStart

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

For Com Addins:

1. 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

or In the End start diagnostic excel

Start> All Programs> Microsoft Office>Microsoft Office Tools>Microsoft Office Diagnostics.