...
- Go to Save > Save to Disk
- There will be three format options that represent Excel file formats: Office 2003 (XLS), Office 2007 (XLSX), Office 2007 with macros (XLSM). These determine what file format is used to render the report from Reporting Services.
See 8.1 - Saving and Deploying Your Excel Report for more information.
...