Excel 2007 Home > Excel 2007 Help and How-to > File conversion and compatibility
Office.comPowered by Bing

Check a workbook for compatibility with earlier versions of Excel

To ensure that a Microsoft Office Excel 2007 workbook does not have compatibility issues that cause a significant loss of functionality or a minor loss of fidelity in an earlier version of Excel, you can run the Compatibility Checker. The Compatibility Checker finds any potential compatibility issues and helps you create a report so that you can resolve them.

 Important   When you work on a workbook in Compatibility Mode, where the workbook is in Excel 97-2003 Binary file format (BIFF8) instead of the new Office Excel 2007 XML-based file format (.xlsx), the Compatibility Checker is automatically run when you save a workbook.

  1. In Office Excel 2007, open the workbook that you want to check for compatibility.

ShowHow to open a workbook

  1. Click Microsoft Office Button Button image, and then click Open.
  2. In the Look in list, click the drive, folder, or Internet location that contains the workbook that you want to open.
  3. In the folder list, locate and open the folder that contains the workbook.
  4. Click the workbook, and then click Open.
  1. Click Microsoft Office Button Button image, click Prepare, and then click Run Compatibility Checker.
  2. To check the workbook for compatibility every time that you save it, select the Check compatibility when saving this workbook check box.
  3. To create a report in a separate worksheet of all the issues that are listed in the Summary box, click Copy to New Sheet.

 Tip   If available, you can click Fix to resolve simple issues. For more complex issues, click Help for more information.