Compatibility Checker

In Excel 2010, you can more easily run the compatibility checker to verify that your workbook is compatible with Excel 97-2003 and Excel 2007.
Try Office 365!

Use these options to examine, locate, and find solutions for the compatibility issues between Microsoft Office Excel 2007 and earlier versions of Excel that were found in your workbook. Compatibility issues can cause a significant loss of functionality or a minor loss of fidelity.

Summary     In this box, the Compatibility Checker lists all of the compatibility issues it found, such as new or improved features or functionality that you used in an Office Excel 2007 workbook that are not supported in an earlier version of Excel. The box also lists the number of times that an issue occurs in the workbook. You can click Find to locate the issues. If available, you can click Fix to resolve simple issues. To help resolve more complex issues, click Help for more information.

Check compatibility when saving this workbook     Select this check box if you want to check your workbook for compatibility issues every time you save it. This check box is selected by default when you work in Office Excel 2007 Compatibility Mode.

Copy to New Sheet      Click this button to copy a report that contains all of the issues that were found (including their location in the workbook) to a separate worksheet.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

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

Thank you for your feedback!

Change language