SAP Knowledge Base Article - Public

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

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

  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

Cause

 Live Office objects get corrupted when refreshed within Dashboard Design.

Resolution

 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

Keywords

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

Product

SAP BusinessObjects Dashboards 4.0