Skip to Content
Author's profile photo Bharath Ramamurthy

How to recover Analysis Add-in in SBOP Analysis, edition for Microsoft Office?

How to recover Analysis Add-in in SBOP Analysis, edition for Microsoft Office?

On rare occasions, Analysis Add-in might get disabled.

This can be due to several reasons. Excel crash, unexpected closure of document etc.

Microsoft Excel detects such crashes and automatically disables Analysis add-in.

In suchcases, you can follow the below steps to recover Analysis add-in.

  1. Launch Excel or Analysis Office.
  2. Goto Office –> Excel Options
  3. Goto Add-Ins.IMG1.png
  4. Select Disabled Items from the Manage dropdown.
  5. Click on GO button.IMG2.png
  6. Select Analysis Add-in and click on Enable button.
  7. Select COM Add-Ins from the Manage dropdown.IMG3.png
  8. Click on GO button.
  9. Select the checkbox Analysis.IMG4.png
  10. Click on OK button.
  11. Hurray! Analysis Add-In is back.


What to do when Analysis Add-In is inactive?:

In case the Analysis add is inactive

  1. Goto Office –> Excel Options
  2. Goto Add-Ins.IMG1.png
  3. Select Analysis from the list of inactive application add-ins.
  4. Select COM Add-Ins from the dropdown and click on go.


5. Select Analysis from the list and click on OK.


6. Now Analysis add-in will be active and available in the ribbon menu.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Venu Gopal
      Venu Gopal

      We come across these simple errors...Good article and well explained with screenshots.


      Venu Gopal

      Author's profile photo Former Member
      Former Member


      Sometimes even doing this manual enabling of COM addins does not helps and when you close excel and reopen, then Analysis menu is not available.

      Their is a permanent solution available to this given by SAP in below URL:



      Author's profile photo Hernando Paez
      Hernando Paez

      Bharath thank You for your contribution I solved the problem.