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

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.