Welcome to the Business Warehouse troubleshooting. You will find here most of the error messages, their meaning and solutions.

This troubleshooting relates to "Analysis - The troubleshooting for the Analyzer has been moved here.

After an Excel crash, the Analysis menu is no longer visible.

Problem: After a Microsoft Excel crash, you reopened Analysis but the Analysis bar is no longer visible in the menu with the following error message :

Solution: To solve this you need to re-active the Analysis plug-in which has been deactivated by Excel.

  1. Open Excel  -> File - >Options

  2. Open "Options" -> Add-Ins" -> In Manage, select "Disabled Items“ -> Go.
  3. In the "Disabled Items" dialog box, select the Analysis Add-In.
  4. In Manage box, select "COM Add-ins", press Go
  5. Check the box in front of "Analysis", then click OK.
  6. Then Analysis ribbon is activated.

 

Unable to see the workbook structure in Design Panel / Components tab

Problem : Unable to see the workbook structure in Design Panel / Components tab

Solution : 

  1. Right click on desktop, and select "Personalize".
  2. Click on Display.

  3. Select "Smaller - 100%(default)", and apply. You need to relogon to make the change effective.