Page 25 of 27PREVNEXT

Up to speed with Excel 2007

New Excel files types: .xlsx, .xlsm, .xltx and .xlsb

File types you can choose when you save your files in Excel 2007.

There are several file types you can choose from when you save a file in Excel 2007.

Excel Workbook (*.xlsx)      Save a workbook as this file type if it does not contain macros or Microsoft Visual Basic for Applications (VBA) code. If you try to save a workbook as an Excel Workbook, and there are any macro commands or VBA projects in the file, Excel 2007 will warn you that the macro or VBA code will be deleted from the file.

Excel Macro-Enabled Workbook (*.xlsm)     Save your workbook as this file type when the workbook contains macros or VBA code. If you try to save a workbook containing macros or VBA as the Excel Workbook file type, Excel will warn you against this choice.

Excel Template (*.xltx)     Save your workbook as this file type when you need a template.

Excel Macro-Enabled Template (*.xltm)     Save your workbook as this file type when you need a template and the workbook contains macros or VBA.

Excel Binary Workbook (*.xlsb)     Save your workbook as this file type when you have an especially large workbook; this file type will open faster than a very large Excel Workbook will. You'll still have the new Excel features with this file type, but not XML.

Excel 97 - Excel 2003 Workbook (*.xls)     Save your workbook as this file type when you need to share it with someone who is working with a previous version of Excel, and who does not have the Microsoft Compatibility Pack for Office 2007.

Microsoft Excel 5.0/95 Workbook (*.xls)     Save your workbook as this file type when you need to share it with someone using Microsoft Excel 5.0. Most Excel 2007 features will be disabled when you save as this file type.

Page 25 of 27PREVNEXT