Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

Office Excel 2007 supports the use of a new XML-based file format that Microsoft officially calls the Microsoft Office Open XML format. This new file format carries the filename extension .xlsx for Excel workbooks and .xlsm for macro-enabled workbooks. The new format is more efficient, resulting in smaller file sizes and offering superior integration with external data sources. Excel 2007 automatically saves any new workbook you create with the .xlsx extension unless you choose to save the file in a different format.

Fortunately, Excel 2007 has no trouble opening any workbook files saved in the .xls file format used by Excel versions 97 through 2003. More importantly, the program automatically saves all editing changes you make to these files in this original file format, and it warns you if you add a new Excel 2007 element to the existing workbook that’s not supported by its earlier versions.

Running the Compatibility Checker

You also can run the Compatibility Checker in Excel 2007 to find any potential compatibility issues if you plan to save the file in the Excel 97–2003 file format. To use this feature, follow these steps:

  1. In Excel 2007, open the workbook you want to check.

  2. Click the Office button, point to Prepare, and click Run Compatibility Checker.

    The Microsoft Office Excel – Compatibility Checker dialog box appears. Any features that might cause issues are listed in the Summary box.

  3. Click OK to close the dialog box.

If you’re working in an office environment where all the workbooks you produce with Excel 2007 must be saved in the old Excel 97–2003 file format for compatibility, you can change the program’s default Save setting so that the program always saves all new workbooks in the older file format. To do this, open the Save tab of the Excel Options dialog box (Office button→Excel Options) and then select Excel 97–2003 Workbook in the Save Files in This Format drop-down list.

Displaying filename extensions within Excel

By default, filename extensions such as .xlsx and .xls do not appear as part of the filename in the File Name text box in the Save As dialog box. However, you can change a setting in Windows to display these filename extensions. Follow these steps:

  1. Open the Documents window in Windows Vista or the My Documents window in Windows XP.

  2. Choose Tools→Folder Options.

    In Windows Vista, you may need to press the Alt key in order to see the menu bar.

    The Folder Options dialog box appears.

  3. Click the View tab.

  4. Remove the check mark from the Hide Extensions for Known File Types check box.

  5. Click OK.

Excel 2007 also supports a new binary file format called Office Excel 2007 Binary, or BIFF12, that carries the .xlsb filename extension. Select this binary format for huge spreadsheets that have to be backward compatible with earlier versions of Excel.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: