SAP Knowledge Base Article - Public

2736388 - How to enable the Analysis Add-In after system crash

Symptom

When opening Analysis for Microsoft Excel or Microsoft PowerPoint, the below message pops up:

"The launcher was not able to connect Analysis Add-In. Make sure that Analysis Add-In is not disabled by Office Appication"

640B283A.PNG

And the Analysis Add-In is not visible in the menu.

analysis tab.png

Environment

  • SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Start MS Excel
  2. Confirm that Analysis Office is available in the installed programs in the machine

  3. Confirm Analysis and Analysis Design tab are missing

Cause

Analysis Add-In has been disabled.

When Microsoft Excel or Microsoft PowerPoint crashes, below message pops up:

"Excel is running into problems with the 'analysis' add-in. If this keeps happening, disable this addin-in and check for available updates. Do you want to disable it now?"

744226F3.PNG

If click "Yes", the Analysis Add-In will be disabled by the Microsoft application. To avoid Analysis Add-In being disabled, it is recommended to click "No".

Resolution

Renable the Analysis Add-In in Microsoft Excel or Microsoft PowerPoint.

  1. Choose File in Microsoft Excel or Microsoft PowerPoint.
  2. In Microsoft Excel, press Excel Options. In Microsoft PowerPoint, press PowerPoint Options.
  3. In the Excel Options dialog box and in the PowerPoint Options dialog box in the categories pane, select Add-Ins.
  4. In the Manage box, select Disabled Items.
  5. Press Go....
  6. In the Disabled Items dialog box, select the Analysis Add-In.
  7. Press Enable.
    Disabble.PNG
  8. In the Manage box, select COM Add-Ins.
  9. Press Go....
  10. In the COM Add-Ins dialog box, make sure that Analysis option is activated.
  11. Press OK. 
    com.png

See Also

2541186 - Analysis Office is not visible in Excel after a successful installation

Keywords

Analysis for Excel, Analysis for office, tab, ribbon, AO, AFO, hidden, missing, disappear, menu, not available, not visible, do not appear, does not appear, started, starting, empty, add-ins, addins, com add-ins, disabled items, list , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions