SAP Knowledge Base Article - Public

3471760 - Error When Opening Report Using "Open with Microsoft Excel" Option

Symptom

You can see these following errors when opening a report using "Open with Microsoft Excel" option:

  • This page contains the following errors:
  • error on line 1 at column XXX: EntityRef: expecting ';'
  • Below is a rendering of the page up to the first error.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP Business ByDesign
  • SAP Cloud for Customer

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports work center view.
  3. Open a Report.
  4. In C4C, click on More Actions (i.e. Three Dots button).
  5. In ByD, click on Share > Navigate to.
  6. In C4C, select "Open with Microsoft Excel".
  7. In ByD, select "Microsoft Excel".
  8. Open XML downloaded by using a Browser.
  9. You can see following error:

Cause

The file downloaded is supposed to be opened in MS Excel and you should have the SAP Excel-Add In installed before hand. The "Open with Microsoft Excel" gives you an option to open your report using the Microsoft Excel add-in.

Resolution

You need to install SAP Microsoft Excel Add-In and then you can use "Open with Microsoft Excel" feature.

If you want to download report results and you do not need to change report selection and report view, you can use Download feature. The "Download" feature allows you to download the report to Microsoft Excel in XML, XLSX, or CSV format. Note that the report opens in read only mode. 

See Also

For SAP Cloud for Customer:

Working with the More Actions Menu 

For SAP Business ByDesign:

Working with Reports and Plans in Microsoft Excel®

Opening Reports

Keywords

Open with Microsoft Excel, report, error, business analytics, ms excel, excel, This page contains the following errors, error on line 1 at column XXX: EntityRef: expecting, Below is a rendering of the page up to the first error. , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer core applications all versions

Attachments

Pasted image.png