Analysis Office is not visible in Excel after a successful installation

Symptom

After installing Analysis for Office and opening Excel by clicking the Excel shortcut from the Windows menu, the ‘Analysis’ tab does not appear in Excel.

When I go to Excel > Options > Add-Ins > COM Add-ins, the ‘Analysis’ add-in is not listed

You can see in below image that ‘Analysis’ add-in is not listed

Environment

• SAP Analysis 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;
• 
• 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.

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.

Excel COM add is not loading during startup and have to add it manually:

Excel COM add-in is not loading when I start Excel, and I have to add it manually every time. When I check under File > Options > Add-ins > Manage > COM Add-ins, I see that the add-in is ‘Unloaded.’ I’m not sure how to make it load automatically at startup.

Solution:

1. Go to Start and type “regedit” to open the Registry Editor.
2. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins.
3. Find SapExcelAddin and change the value of LoadBehaviour to 3. This add-in was not loading at startup for me (the picture is just an example).
4. Close the Registry Editor and reopen it to make sure the value hasn’t changed.
5. Restart Excel.