1447398 - Cannot Access External Data when refreshing a LiveOffice connection

SAP Knowledge Base Articles - public

1447398 - Cannot Access External Data when refreshing a LiveOffice connection


  • When refreshing a LiveOffice connection in Xcelsius you receive the error:  Cannot Access External Data
  • Detailed error message:
    'An error has occurred.
    For more information contact the file creator or your system administrator.
    Error {0}
    Connection Type: {1}

Reproducing the Issue

  1. Launch Xcelsius
  2. From the menu select Data > Import
  3. From the Common Dialog window to select the file to import, locate a MS Excel document containing Live Office data, select it and click on Open
    the MS Excel document with LiveOffice Data is inserted in the grid
  4. From the Xcelsius menu select Data > Connections
    the Data Manager screen is displayed
  5. Click on Add
  6. Select Live Office Connections
  7. Select the connection displayed on the left pane of the Data Manager window
  8. Leave the Session URL as it is
  9. Click on the Usage Tab
  10. Check the Refresh Before Components Are Loaded option
  11. Click on Close
  12. Insert a component i.e. Pie Chart and set the properties for the Data Values
  13. From the Components / Web Connectivity drag and drop a Connection Refresh Button onto the canvas
  14. Select the Connection Refresh Button
  15. goto the Properties panel
  16. Click on the Behavior tab
  17. Check the Refresh After Components Are Loaded option
  18. Click on the Preview button which is in the toolbar: the error is thrown



  • specify the correct Session URL in the Data Manager panel:
  1. From the menu select  Data > Connections
  2. Select the first available connection on the left pane of the Data Manager screen
  3. Specify a valid URL in the Session URL
  4. if there are other connections do the same for each one of them


KBA , BI-RA-XL , Dashboards and Presentation Design , How To


SAP BusinessObjects Xcelsius Enterprise 2008