SAP Knowledge Base Article - Public

2761642 - When exporting a report to Excel from Crystal Reports, is it possible to rename the Worksheet?

Symptom

  • Worksheet name: Sheet1
  • How to rename the Excel worksheet?
  • When exporting a report to MS Excel from Crystal Reports, the worksheet names in Excel are always like: Sheet1, Sheet2, etc.
  • How to specify the names of the worksheet when exporting a report to MS Excel from Crystal Reports?

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. In Crystal Reports create a report based on any data source.
  2. Export the report to MS Excel format.
  3. Notice the worksheet name is: Sheet1

Cause

  • There is no option to specify worksheet names when exporting to MS Excel from Crystal Reports.

Resolution

  • In MS Excel, manually change the worksheet name after the report is exported to MS Excel.

Keywords

CR, xls , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020