Excel 2010 crashes when opening
Following the December 12, 2010 Office update from Microsoft, a very few Excel 2010 users have been experiencing crashes when the Spreadsheet Assistant opens in 2010. Other versions of Excel are not affected. If Excel 2010 crashes due to the Spreadsheet Assistant, do the following:
- If you have not already done so, open Excel 2010. Agree to disable the Spreadsheet Assistant when Excel advises it should be disabled.
- Close Excel if it is open.
- Run the XLB File Deleter. Have it search just documents and settings. It will find "excel14.xlb". This is a file Excel recreates each time it opens and closes. Agree to delete this file. It may find other xlb files but they will be excel12.xlb for 2007 or excel11.xlb for 2003. They do not need to be deleted. The XLB stores custom toolbars and graphics. Excel will recreate it.
- Open Excel 2010. Click on green File tab, Options, Add-ins
- Click the GO button beside manage Excel add-ins
- Click the Browse button. Go to My Computer or Computer, C Drive or C Folder, Program Files (x86) if you see one with (x86) as part of its name. If no Program Files (x86) folder, open the Program Files folder. Windows 7 computers usually have both and our product is installed in the x86 Program Files folder.
- Open the Add-ins folder in this location. It is not the default addins folder you first see when you click the browse button.
- Select just "assistnt.xla" and then do OK's to close the dialogs. You may need to close and re-open Excel. This will open the XLA version of the Spreadsheet Assistant. It has the same version as the XLAM version.
- Do not install the Spreadsheet Assistant from the Productivity Suite Add-in Manager as it will automatically install the 2007-2010 XLAM version. We are working on an update to the Add-in Manager to allow one to pick the XLA vs the XLAM version.