Saves a workbook as a tab-delimited text file for use on another Microsoft Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Note: This format is supported in Excel Starter only. Spreadsheet saved in Microsoft Works 6.0-9.0. You can open a workbook in this file format in Excel 2010, but you cannot save an Excel file to this file format. Supports the use of VBA projects.Īn Excel 4.0 file format that saves only worksheets, chart sheets, and macro sheets. The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm). An Add-In is a supplemental program that is designed to run additional code. The XML-based and macro-enabled Add-In format for Excel 2010 and Excel 2007. XML Spreadsheet 2003 file format (XMLSS). The Excel 5.0/95 Binary file format (BIFF5). The Excel 97 - Excel 2003 Binary file format (BIFF8) for an Excel template. The Excel 97 - Excel 2003 Binary file format (BIFF8).

Stores VBA macro code or Excel 4.0 macro sheets (.xlm). The macro-enabled file format for an Excel template Excel 2010 and Excel 2007. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm). The default file format for an Excel template for Excel 2010 and Excel 2007. The binary file format (BIFF12) for Excel 2010 and Excel 2007. The XML-based and macro-enabled file format for Excel 2016, Excel 2013, Excel 2010, and Excel 2007. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm). The default XML-based file format for Excel 2010 and Excel 2007. However, you also have the option to continue to work in Compatibility Mode, which retains the original file format for backward compatibility. To take advantage of the new features of Excel 2010, you can save the workbook to an Excel 2010 file format.

If you open an Excel 97-2003 workbook, it automatically opens in Compatibility Mode. To open a file that was created in another file format, either in an earlier version of Excel or in another program, click File > Open. Note: Whenever you save a file in another file format, some of its formatting, data, and features might not be transferred.

Office clipboard excel