Open file extension xls: Microsoft Office Excel 97-2003 Worksheet. Application/msexcell, application/softgrid-xls, application/vnd.ms-excel, x-softmaker-pm.
![Microsoft excel 97-2003 worksheet (.xls) download Microsoft excel 97-2003 worksheet (.xls) download](/uploads/1/2/6/3/126306908/724147840.png)
If you save your Excel files in 97-2003 format (.xls instead of the new .xlsx format), users who do not have Excel 2007 or later installed on their computer, can still open your Excel files.
1. Open a workbook.
2. On the File tab, click Save As.
3. Select Excel 97-2003 Workbook (*.xls) from the drop-down list.
4. Click Save.
To automatically save your Excel files in 97-2003 format, execute the following steps.
5. On the File tab, click Options
6. On the left side, click Save and select Excel 97-2003 Workbook from the drop-down list.
7. Click OK.
Note: Excel will always give you a warning if features are not supported in 97-2003 format, so you can save the file in the new .xlsx format (Excel Workbook).
-->This topic explains how to work around the Excel 2003 row limitation when you export paginated reports to Excel. The workaround is for a report that contains only a table.
Important
The Microsoft Excel 2003 (.xls) rendering extension is deprecated. For more information, see Deprecated Features in SQL Server Reporting Services in SQL Server 2016.
Excel 2003 supports a maximum of 65,536 rows per worksheet. You can work around this limitation by forcing an explicit page break after a certain number of rows. The Excel renderer creates a new worksheet for each explicit page break.
To create an explicit page break
- Open the report in SQL Server Data Tools - Business Intelligence or the Reporting Services web portal.
- Right click the Data row in the table, and then click Add Group > Parent Group to add an outer table group.
- Enter the following formula in the Group by expression box, and then click OK to add the parent group.=Int((RowNumber(Nothing)-1)/65000)The formula assigns a number to each set of 65000 rows in the dataset. When a page break is defined for the group, the expression results in a page break every 65000 rows.Adding the outer table group adds a group column to the report.
- Delete the group column by right-clicking on the column header, clicking Delete Columns, selecting Delete columns only, and then click OK.
- Right click Group 1 in the Row Groups section, and then click Group Properties.
- On the Sorting page of the Group Properties dialog box, select the default sorting option and click Delete.
- On the Page Breaks page, click Between each instance of a group and then click OK.
- Save the report. When you export it to Excel, it exports to multiple worksheets and each worksheet contains a maximum of 65000 rows.