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.

Was this information helpful?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!