How to save Excel files in 97-2003 Format


If an excel user is running an older version of the program (Excel 2003 or older) they will be unable to view documents in the new .xlsx format. In order to enable users running older versions of Excel to open files that were made in newer versions it is possible to save files in the old 97-2003 .xls format.
This tutorial will show you step-by-step how to save an Excel spreadsheet in this format.
1. Start by opening a workbook in Excel.
2. Click on the green File tab on the top left-hand corner, and select Save As.
File tab on top left-hand corner
File tab on top left-hand corner

Save As option after having clicked the File tab
Save As option after having clicked the File tab
3. After clicking on Save As, select the Excel 97-2003 Workbook option from the drop-down list.
Select Excel 97-2003 Workbook option from drop-down list
Select Excel 97-2003 Workbook option from drop-down list
4. After having selected the Excel 97-2003 option from the drop-down list, click Save.
It is also possible to automatically save Excel files in the 97-2003 format by performing the following steps.
1. After clicking the File tab, select Options.
Select Options after having clicked the File tab
Select Options after having clicked the File tab
2. After having opened Options, click Save and select Excel 97-2003 Workbook from the drop-down list and click OK.
Select Excel 97-2003 Workbook from the drop-down list.
Select Excel 97-2003 Workbook from the drop-down list

It is important to note that some features of newer versions of Excel are not supported by the Excel 97-2003 Format, and can only be saved in the newer .xlsx format.

Total Pageviews

2016 © BiztechCS
Planer theme by BiztechCS