Symptom
The symptoms below might appear at random:
- The “Analysis” ribbon on the Excel tool-bar disappearing at random, requiring users to go to the COM add-ins menu and manually re-check the Analysis add-in. The Analysis icon reappears after doing so.
- Same symptoms as above, but the Ribbon does not reappear upon re-checking the add-in. The user is forced to open Analysis for Excel through the desktop Start menu. The Analysis icon reappears after doing so.
- After performing both troubleshooting methods above, the Analysis add-in is still not working.
Environment
- SAP BusinessObjects Analysis 2.0, edition for Microsoft Office
- SAP BusinessObjects Analysis 2.1, edition for Microsoft Office
- SAP BusinessObjects Analysis 2.2, edition for Microsoft Office
- SAP BusinessObjects Analysis 2.3, edition for Microsoft Office
Reproducing the Issue
Launch Analysis for Microsoft Excel and the symptoms described above appears at random.
Resolution
This issue is resolved in AO 2.4 SP 2 and higher versions.
Install the latest version of Analysis Office by visiting this link and following the instructions in section #2.
Keywords
Analysis for Office, AO, A4O, toolbar, ribbon , KBA , BI-RA-AO-XLA , Excel Addin , Problem
Product
SAP BusinessObjects Analysis 2.0, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.1, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.2, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.3, edition for Microsoft Office