SAP Knowledge Base Article - Public

1525949 - Adding a data set based off of an Excel file fails with an error.


When an Excel spreadsheet is used as the data source for a new dataset in,  the data set fails to upload to  An error indicating "Something went wrong" appears after a long wait.


Excel workbooks containing unused worksheets can occasionally prevent the xls file from being uploaded to


Please follow the steps outlined below:

  1. Open the Excel workbook.
  2. At the foot of the workbook, click on any unused worksheets.  Note, typically there will be 2 unused worksheets as a default.
  3. Right click on the unused worksheet and select "Delete"
  4. Repeat for subsequent unused worksheets.
  5. Save the Excel file
  6. Re-upload the xls file to


KBA , BI-OD-BI , Business Intelligence OnDemand , Problem


SAP Crystal Reports XI R2