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.

    How to open a workbook

    1. Click Microsoft Office Button Office 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.

  2. Click Microsoft Office Button Office button image , click Prepare, and then click Run Compatibility Checker.

  3. To check the workbook for compatibility every time that you save it, select the Check compatibility when saving this workbook check box.

  4. 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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!