SAP Knowledge Base Article - Public

1202967 - Crystal report produces same output when exported to two different Excel formats


When a Crystal report is exported to Microsoft Excel format, there are two options available

  • MS Excel 97-2000
  • MS Excel 97-2000 (Data only)

On one particular computer both export options produce the same Excel output instead of the expected different Excel formats.


This is due to the user's Windows profile that has been used to log on to the computer.


To resolve this behavior perform the following steps:

  1. Back up and remove the user's existing profile.
  2. Create a new Windows profile for the user.


In Crystal Report when using both Excel export options, it results in the same output , 651168 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed


SAP Crystal Reports XI ; SAP Crystal Reports XI R2