SAP Knowledge Base Article - Public

1716510 - When a dashboard is opened, all Live Office options are grayed out.


 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

  1. Open the dashboard with Live Office connection in Dashboard Design
  2. Refresh all Live Office objects in an Excel sheet
  3. Add Live Office connection in Data Connections 
  4. Save the dashboard
  5. Preview the dashboard and it works fine
  6. Close the dashboard
  7. 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:

  1. Add Live Office objects in Microsoft Excel outside Dashboard Design
  2. Save the Excel file
  3. Open Dashboard Design
  4. Import the saved Excel file
  5. Drag required components on a canvas
  6. Go to Connections in Data menu of dashboard design and add Live Office connection
  7. Map Dashboard Design component to the excel sheet.
  8. Save/Preview the dashboard


LiveOffice , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem


SAP BusinessObjects Dashboards 4.0