Excel 2010 crashes when opening Spreadsheet Assistant

Questions? E-mail us or call us 302-234-9857, 8AM to 10PM U.S. East Coast Time 7 days a week

Home
Products/Add-ins
Complete Product/Add-in List New Add-ins Trial Versions Accounting Add-ins Business and Risk Analysis Add-ins Charting Add-ins Data Add-ins Downloadable Macro Books Free Add-ins Specialty Add-ins Time Saving Add-ins
Add-in Collections
Productivity Suite Accounting Collection Business Analysis Collection Charting Collection Data Collection Macro Book Collection Risk Analysis Collection Time Saving Collection
Download
Download Information Download Purchased Software Download Upgrades Download Trial Versions Download Free Products
Support
Support How to Contact Us Top Support Questions Money Back Guarantee Ordering FAQ's Product FAQ's How to Open and Use Our Products Excel Questions and Answers Excel Problems & Solutions Links to other Excel sites How to repair Microsoft Excel Need more help? Let us connect computers
Company
About Add-ins.com LLC How to Contact Us Customer Feedback Policies License Agreement

Excel 2010 crashes when opening
Spreadsheet Assistant

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.

Run the latest upgrade to the latest Spreadsheet Assistant.

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.

View Cart

Quantity
Discounts

Order online
Immediate
delivery

Money back
guarantee.

Home * About * Contact * Feedback * Upgrades * Money Back Guarantee * FAQ's
Download Information * Ordering Questions * Support
Product List * New Products * Free Products * Trial Versions * Products by Others