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
- Go to Business Analytics work center.
- Go to Design Reports work center view.
- Open a Report.
- In C4C, click on More Actions (i.e. Three Dots button).
- In ByD, click on Share > Navigate to.
- In C4C, select "Open with Microsoft Excel".
- In ByD, select "Microsoft Excel".
- Open XML downloaded by using a Browser.
- 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:
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
Attachments
Pasted image.png |