Fix Analysis for Microsoft Excel COM Add-in Error 0x80131047
Question details
The Analysis for Microsoft Excel COM add-in fails to load and displays runtime error 0x80131047.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to use the Analysis for Microsoft Excel add-in after an Office update.
- Observed behavior
- The add-in does not load and prompts a runtime error stating that the assembly name or codebase is invalid.
Ensure you have administrator privileges on your computer, as fixing this error requires uninstalling the existing software and installing a new application version.
Reinstall the Latest Analysis for Excel Application
Because standard Office repair does not fix incompatible third-party add-ins, cleanly installing the latest administrator-approved version of the Analysis application is the most effective solution.
Runtime error 0x80131047 typically happens when an Office update changes dependencies, causing the older Analysis for Excel COM add-in to become incompatible. Since the error stems from the add-in's own invalid codebase or assembly name, built-in Office repair tools will not resolve the issue. You must replace the application entirely.
Save your work and fully exit all running instances of Microsoft Excel.
Open the Windows Control Panel, navigate to 'Programs and Features', locate the outdated 'Analysis for Microsoft Excel' application in the list, right-click it, and select 'Uninstall'.
Obtain the latest version of the Analysis for Excel installer approved by your IT administrator. Run the setup file and follow the on-screen prompts to complete the installation.
Restart Microsoft Excel. Go to File > Options > Add-ins. Manage 'COM Add-ins' and click 'Go' to verify that the Analysis add-in is checked and loads successfully without the 0x80131047 error.

Try WPS Office for a Seamless Spreadsheet Experience
If you frequently experience COM add-in conflicts and runtime errors in Microsoft Excel, consider switching to WPS Office. It is a highly compatible, lightweight, and free alternative that seamlessly handles all your spreadsheet needs without bloated external add-in crashes.

Frequently Asked Questions
Why do I get runtime error 0x80131047 in Excel?
This error generally occurs after an Office update when an older COM add-in (like Analysis for Excel) becomes incompatible with the new Excel environment, resulting in an invalid assembly name or codebase.
Will the built-in Microsoft Office online repair tool fix this add-in issue?
No. Online repair and Office updates only fix Microsoft's core files. They typically do not fix third-party or standalone COM add-in compatibility issues. The specific add-in application needs to be updated or reinstalled.
How do I access the COM Add-ins menu to check its status?
Open Excel, click on File, select Options, and then choose Add-ins from the left panel. At the bottom of the window, select 'COM Add-ins' from the Manage drop-down list and click 'Go' to view and manage your active add-ins.
What if reinstalling the add-in still doesn't resolve the 0x80131047 error?
Make sure your IT administrator has provided the correct, fully updated installer that matches your system architecture (32-bit or 64-bit) and the current version of your Office suite. Complete removal of leftover registry keys from the old version may also be required.




