SAP Knowledge Base Article - Public

1286765 - Error: “To get data from a web page into Microsoft Office Excel, you must open excel as an independent application and then perform a web query” while mapping XML data in Xcelsius 2008.

Symptom

  • Adding new xml data into embedded excel spreadsheet within Xcelsius 2008 will give the following error:-"To get data from a web page into Microsoft Office Excel, you must open excel as an independent application and then perform a web query"
  • XML data already present refreshes fine.

Reproducing the Issue

  •  Xcelsius 2008
  1. Launch Xcelsius 2008.
  2. Import an excel file which contains xml mapping in Xcelsius 2008.
  3. Create a dashboard using Excel xml mapping.
  4. Try to map a new xml file in the embedded excel spreadsheet.

Cause

  • Excel allows external data to be inserted only when it is running as an independent application.

Resolution

1) Open the .xls file separately in Excel.

2) Insert the new xml data.

3) Save the file.

4) Re-import the file into Xcelsius dashboard.

Keywords

XML, Excel, Add , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008