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.

Why Save in Excel 97-2003 Format?

1. Compatibility: Some users may still use older Excel versions that do not support the newer .xlsx format.
2. File Size: The .xls format often results in smaller file sizes, making it easier to share via email.
3. Macro Support: Older versions of Excel primarily support VBA macros in the .xls format.
4. Third-Party Applications: Some software tools and systems still require data in .xls format.

Steps to Save an Excel File in 97-2003 Format

To save your Excel workbook in the this format, follow these simple steps:

1. Open Excel and create or open the workbook you want to save.
2. Click on File in the top menu.
3. Select Save As from the options.
4. Click Save.

5. In the Save as type drop-down menu, select Excel 97-2003 Workbook (*.xls).

6. Enter a name for your file.

7. Click Save.

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).

Considerations When Saving in 97-2003 Format

• Feature Loss: Some advanced features, such as slicers, conditional formatting, and large data models, may not be fully compatible with .xls format.
• File Size Limitations: The .xls format supports a maximum of 65,536 rows and 256 columns, compared to the 1,048,576 rows and 16,384 columns supported in .xlsx.
• Performance Issues: .xls files may load more slowly in newer Excel versions due to outdated formatting.
• Security Concerns: .xls files are more vulnerable to macro-based viruses compared to newer file formats like .xlsm.

Conclusion

Saving files in the Excel 97-2003 Workbook format ensures compatibility with older versions of Excel. However, users should be mindful of potential limitations, such as reduced functionality and file size constraints. By understanding when and how to save in this format, you can maintain seamless collaboration with users who rely on legacy systems.