SYMPTOM:
Users find that when they are trying to export any report to Microsoft Excel 2000 from Strategy Web 10.x, or deliver the report in MS Excel format using Strategy Distribution Services 10.x, the MS Excel file that opens just contains HTML code, as shown below:
CAUSE:
This problem occurs because the user has a preference conflict with their version of Microsoft Office. If the user has their Excel Version preference set to ‘Excel XP, Excel 2003, or newer versions’, as shown below, and they are using an older version of Excel, then they are going to encounter this issue.
ACTION:
Users should always confirm that the version of Microsoft Excel that they have on their own machine matches their Excel Version preference setting. Once the user changes the preference to Microsoft Excel 2000, then the reports will show Excel formatting correctly, as shown below:
Third Party Software Installation WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability
