How to Make Excel Files Compatible with Earlier Versions

Date:2020-4-19 Author:Cordelia

If you work with a recent version of Excel like Excel 2016, Excel 2019, the workbook you created may not be displayed correctly in Excel 2003 or Excel 2007. Thus when you send your Excel files to your colleague or friends, there’s a chance they can’t open them normally. In this case, you’d better make these files compatible with earlier Excel versions.

1. Just open the workbook you want to make it compatible, tap File, choose Save AsThis PC (or Browse).

How to Make Excel Files Compatible with Earlier Versions

2. Choose a folder you like to place the compatible file, then select Excel 97-2003 Template (*.xlt) in the drop-down menu of Save as type.

How to Make Excel Files Compatible with Earlier Versions

3. Hit Save button on the bottom to store the xlt file.

How to Make Excel Files Compatible with Earlier Versions

4. Then you can find the Excel file at the place you specified, and open it normally with earlier versions of Excel.

How to Make Excel Files Compatible with Earlier Versions

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *