2143214 - Error When Opening Excel Workbook

SAP Knowledge Base Articles - public

2143214 - Error When Opening Excel Workbook


When trying to open workbook with the Excel add-in you may encounter performance issues or even an error message:

Unexpected error in server communication; session needs to be closed
Message was: The remote server returned an error: (500) Internal Server Error.
(Exception System.Net.WebException)

Reproducing the Issue

  1. Logon to the ByD Excel Addin
  2. Select Open > All Workbooks

It takes a long time to open your workbook or even fails with the above error.


The workbook contains a report which has been designed in the ByD UI and has selection parameters which have been added via Add Fields in the report. This is not advisable as it consumes too much performance internally.


Instead if you want to add some characteristics as selections, you can do it in the report wizard itself. Please convert as many selections fields as possible of such report from Add Fields to selections via the Report wizard (Step 4 > Use as Variable) and then add this report into the workbook. This should improve the performance.


KBA , LOD-CRM-EMP , Employee , How To


SAP Business ByDesign all versions