Symptom
When a dashboard with Live Office connections is opened, all Live Office options in Microsoft Excel are grayed out.
Environment
- Dashboard Design 4.0 Service Pack 2
- Business Intelligence 4.0 Service Pack 2
- Live Office 4.0 Service Pack 2
Reproducing the Issue
- Open the dashboard with Live Office connection in Dashboard Design
-
Refresh all Live Office objects in an Excel sheet
-
Add Live Office connection in Data Connections
-
Save the dashboard
-
Preview the dashboard and it works fine
-
Close the dashboard
-
Re-open the dashboard
Cause
Live Office objects get corrupted when refreshed within Dashboard Design.
Resolution
Perform following steps to add a Live Office connection within Dashboard Design:
-
Add Live Office objects in Microsoft Excel outside Dashboard Design
-
Save the Excel file
-
Open Dashboard Design
-
Import the saved Excel file
-
Drag required components on a canvas
-
Go to Connections in Data menu of dashboard design and add Live Office connection
-
Map Dashboard Design component to the excel sheet.
-
Save/Preview the dashboard
Keywords
LiveOffice , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem
Product
SAP BusinessObjects Dashboards 4.0