SAP Knowledge Base Article - Public

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

Symptom

After installing Analysis for Office and starting MS Excel by clicking the Excel shotcut from windows menu bar, the "Analysis" tab is not visible in Excel.

When going to Excel > Options > Add-Ins, Analysis is not in the list of Add-Ins.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

  • Install Analysis for Office;
  • Confirm that Analysis Office is available in the installed programs in the machine;
  • Start MS Excel by windows menu bar;
  • analysis tab.png
  • Confirm that "Analysis" tab is not available and it is not in the list of add-ins in Excel.

Cause

Analysis for Office was not started in the machine yet after the initial installation.

Resolution

Click the shotcut of Analysis for Office excel from windows menu bar to start Analysis after the initial installation.

shortcut.png

Before users can access Analysis in any Microsoft Excel or Microsoft PowerPoint file, ensure that Analysis has been started once directly in the Windows directory or by choosing the desktop icons.

This information is also available in chapter "To install SAP Analysis for Microsoft Office" in the Administrator Guide of Analysis Office.

See Also

Administrator Guide of AO, available in http://help.sap.com/boao.

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

Keywords

empty, add-ins, addins, com add-ins, disabled items, list, not visible, started, starting, ribbon , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , Problem

Product

SAP Analysis for Microsoft Office all versions