Share via

Analysis for Microsoft Excel Unable to Load/Use

Anonymous
2020-02-20T06:34:12+00:00

Hi, 

I'm not able to use the Analysis for Microsoft Excel after some updates run in my laptop. 

The message show in Load Behavior: Not loaded. A run time error occurred during the loading of the COM Add-in. 

The error message appeared when try to add Analysis in the COM Add-in: The given assembly name or codebase was invalid (Exception from HRESULT: 0x80131047).

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-27T16:43:29+00:00

    Hi George,

    Sorry for not able to update you earlier.

    The issue is now resolved. The IT admin uninstall the previous outdated version and reinstall the latest version. She did some changes here and there where I could not really understand it. After that the issue was fully resolved.

    Really appreciate your help. Thanks a lot.

    Best regards,

    Carol

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-02-22T08:13:33+00:00

    Hi George,

    IT admin already helped me to uninstalled and re-installed the App (Analysis for Microsoft Excel), but issue still unable to resolve.

    please see below screen shots as requested:

    1. Office version

    2. System version

    1. Error message - This is the error prompt when I try to start the launcher
    2. Error message - This is the error prompt when I try to tick "Analysis" in COM Add-ins

    Hope I've provided all necessary information to you.

    Thanks & best regards,

    Carol

    [PII is masked by George Jiang MSFT Support]

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2020-02-21T02:08:14+00:00

    Hi George,

    Thanks for your reply.

    I tried to use the online repairing and updated to latest version. issue still not resolve.

    I'm going to get admin to help me uninstall and see how it goes.

    Thanks & best regards,

    Carol

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-02-20T12:45:41+00:00

    Hi Carol_5784,

    Thanks for using Microsoft product and posting in the community.

    According to your description, the Analysis feature is unable to use for the codebase was invalid.

    Here are my suggestions may help you:

    1. Online Repairing Office applications.
    2. Update the version to the latest, if the version isn’t the latest.

    You could compare your Office version(go to Excel> select File>Account, version number is in About Excel, don’t click About Excel) with the Update history for Office 365 to confirm whether your Office version is the latest or not.

    If the issue still persists, could you provide us more information to narrow down the issue.

    1. You system version and Office version(go to Excel>select File>Account and take the screenshot of Product Information, do not click About Excel)

    System version: Click Windows logo key + R> Enter winver> OK

    1. The screenshots for error messages.
    2. Since you have mentioned the issue happens when you try to add Analysis, the Analysis ToolPak is a default Excel add-in and already presents in Excel add-ins. If you added another add-in, then what is the detailed name of add-in ?

    Please feel free and post back. We are always willing to help you.

    Regards,

    George

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-02-20T08:32:10+00:00

    Run an inplace Office repair

    Was this answer helpful?

    0 comments