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
- In Crystal Reports create a report based on any data source.
- Export the report to MS Excel format.
- 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