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:
- Back up and remove the user's existing profile.
- 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