Spreadsheet Content Not Saved for Reports Saved in XLS Format
If you open a report that was saved in XLS format
or run a report in XLS format, and security settings in your Web browser
are set so that you are prompted to open or save the report, do not
click Save. If you save the report, the spreadsheet
content will not be saved. This is because Microsoft Excel reports in Microsoft Office 2000 HTML format use relative
paths to the spreadsheets. The relative URL paths are no longer available
when you open a saved XLS report.
Instead, click Open first and then choose to save the report.