How should you save a file if you want it to be compatible with older versions of microsoft excel?

For a list of file formats (also called file types) you can (and can’t) open or save in Excel 2022, run into File formats that are supported in Excel at the terminate of this article.

1. Open the workbook you want to relieve.

2. Click
   File
   >
   Save As.

   

3. Nether
   Places, pick the place where you want to salvage the workbook. For example, pick
   OneDrive
   to save it to your Web location or
   Computer
   to save it in a local folder like your
   Documents.

   

4. In the
   Save Every bit
   dialog box, navigate to the location you want.

   

5. In the
   Relieve every bit type
   list, click the file format y’all want. Click the arrows to scroll to file formats that aren’t visible in the list.

   Note:The file formats you’ll encounter vary, depending on what type of sail is active in your workbook (a worksheet, chart sheet, or other type of sheet).

6. In the
   File name
   box, accept the suggested name or type a new proper name for the workbook.

If you opened an Excel 97-2003 workbook but don’t need to continue information technology in that file format, but convert information technology to the electric current file format (.xlsx).

1. Click
   File
   >
   Info.

2. Click
   Convert.

In Excel 2022, yous tin can open and save files in the following file formats:

Excel file formats

Text file formats

Notation:If you relieve a workbook in any text format, all formatting is lost.

Other file formats

File formats that use the clipboard

If you copied information to the clipboard in ane of the following file formats, y’all can paste it into Excel using the
Paste
or
Paste Special
command (Home
>
Clipboard
>
Paste).

File formats that are non supported in Excel 2022

The following file formats are no longer supported, then you can’t open or save files in these file formats.

To piece of work with your workbook data in a program that isn’t supported anymore, endeavor the following:

• Search the Web for a company that makes file format converters for file formats that aren’t supported in Excel.

• Relieve your workbook to another file format that can be opened in the other program. For instance, save to an XML spreadsheet or text file format that the other program might back up as well.

You tin can salvage an Excel 2007 or later workbook in the file format of an earlier version of Excel, in a text file format, and in other file formats, such as PDF or XPS. By default, files are saved in the .xlsx file format, but you can change the default file format for saving. If you ofttimes use the
Salve As
command, you lot may want to add it to the Quick Access Toolbar.

Of import:If you relieve a workbook in a file format other than the current Excel file format, formats and features that are unique to Excel 2007 and afterwards will not be retained. For more information, see Utilise Excel with earlier versions of Excel.

1. In Excel, open the workbook that yous want to salvage for use in another plan.

2. On the
   File
   tab, click
   Save As.

3. To relieve the workbook to a different location, specify the drive and location in the file path and folder boxes.

4. In the
   File name
   box, take the suggested name or type a new name for the workbook.

5. In the
   Save as type
   listing, click the format that yous know you can open up in the other program.

If needed, click the arrows to scroll to file formats that are non visible in the list.

Note:The file formats that are available vary, depending on what blazon of sheet is active (a worksheet, chart canvas, or other type of canvas).

Tip:For more than information on how to save a workbook in PDF (.pdf) or XPS (.xps) file formats, come across Salve as PDF or XPS.

You tin save any file format that you tin can open up in Excel 2007 and later in the current Excel Workbook file format (.xlsx). By doing this, you can use new features that are not supported past other file formats.

Note:When you save a workbook that was created in an before version of Excel as an Excel 2007 and later workbook, some formats and features may not be retained. For information on unsupported Excel 97-2003 features, see Use Excel with earlier versions of Excel.

1. Open up the file that you desire to save in the electric current file format.

2. On the
   File
   tab, click
   Relieve As.

3. To save the file to a unlike location, specify the drive and location in the file path and folder boxes.

4. In the
   File name
   box, take the suggested name or type a new name for the workbook.

5. In the
   Save every bit type
   list, exercise one of the following:

   • If y’all are saving a workbook that was created in an earlier version of Excel, and the workbook contains macros that you lot want to retain, click
     Excel Macro-Enabled Workbook (*.xlsm).

   • If y’all want to relieve the workbook as a template, click
     Excel Template (*.xltx).

   • If you are saving a workbook that was created in an earlier version of Excel, the workbook contains macros that you want to retain, and y’all want to save the workbook as a template, click
     Excel Macro-Enabled Template.xltm.

   • If y’all want to salve the workbook in the current Excel Workbook file format, click
     Excel Workbook (*.xlsx).

   • If you want to save the file in the new binary file format, click
     Excel Binary Workbook (*.xslb).

6. Click
   Save.

You can change the file type that is used past default when you save a workbook.

1. On the
   File
   tab, click
   Options.

2. In the
   Salvage
   category, nether
   Salvage workbooks, in the
   Salvage files in this format
   box, click the file format that you want to employ by default.

The
Relieve As
control is not available as a button on the ribbon. Yous can, however, add the command to the Quick Access Toolbar.

1. Click the dropdown arrow on the Quick Access Toolbar, and and so click
   More than Commands.

   

2. In the
   Cull commands from
   box, make sure that
   Popular Commands
   is selected.

3. In the list box, curlicue to the
   Relieve Equally
   push button, and so select it.

4. Click
   Add together.

You can save a Microsoft Part Excel 2007 workbook in a unlike file format. Yous tin can save a workbook in an earlier version file format, in text file format, and in other file formats, such as PDF or XPS. Yous tin also relieve any file format that yous can open in Function Excel 2007 as an Excel 2007 workbook. By default, Excel 2007 saves files in the .xlsx file format, but you tin modify the default file format for saving.

If you lot frequently use the
Save Every bit
command, y’all may desire to add it to the Quick Admission Toolbar.

Y’all can save whatever file format that you lot can open in Excel 2007 in the current Excel Workbook file format (.xlsx). Past doing this, you tin use the new features of Excel 2007, such as the larger filigree, that are non supported past other file formats.

Annotation:When you salvage a workbook that was created in an earlier version of Excel equally an Excel 2007 workbook, some formats and features may not be retained.

1. Open the workbook that you lot want to salve as an Excel 2007 workbook.

2. Click the
   Microsoft Office Button
   

   
   , and then click
   Save Equally.

3. In the
   File name
   box, accept the suggested name or type a new name for the workbook.

4. In the
   Save as type
   list, practise ane of the following:

   • If you are saving a workbook that was created in an earlier version of Excel, and the workbook contains macros that y’all desire to retain, click .xlsm.

   • If you want to salvage the workbook as a template, click .xltx.

   • If yous are saving a workbook that was created in an earlier version of Excel, the workbook contains macros that you want to retain, and y’all want to salve the workbook equally a template, click .xltm.

   • If you desire to salve the workbook in the current Excel Workbook file format, click .xlsx.

   • If you want to salve the file in the new binary file format, click .xslb.

   • For more information about file formats, run into File formats that are supported in Excel.

5. Click
   Salvage.

You can modify the file type that is used past default when you save a workbook.

1. Click the
   Microsoft Part Button
   

   
   , and then click
   Excel Options.

2. In the
   Save
   category, nether
   Save workbooks, in the
   Save files in this format
   box, click the file format that you want to utilise by default.

The
Save Every bit
command is not bachelor every bit a button on the Microsoft Office Fluent user interface Ribbon. You can, however, add the command to the Quick Access Toolbar.

1. Click the
   Microsoft Part Button
   

   
   .

2. Right-click
   Save As, and so click
   Add to Quick Admission Toolbar.

Which format should you use to save a file if you want it to be compatible with earlier versions of Microsoft Excel?

How do I save an Excel file not in Compatibility Mode?

How do I open an older version of an Excel file?

What does Excel Compatibility Mode mean?