When a dashboard with Live Office connections is opened, all Live Office options in Microsoft Excel are grayed out.
- 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
Live Office objects get corrupted when refreshed within Dashboard Design.
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
LiveOffice , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem
SAP BusinessObjects Dashboards 4.0