Microsoft Office Tutorials and References
In Depth Information
Check for Features Not Supported by Earlier Excel Versions
Chapter 2: Making It Easier to Manage Workbooks
6 Click the Select Versions
to Show drop-down
7 Click an Excel version if
you do not want to see
compatibility issues for
Excel displays the
To see the specific cell,
range, or object that has
the problem, you can
click the Find link.
8 Click OK.
If you have other changes to make to the workbook before distributing the file, you
may prefer to check compatibility as you go along. Rather than running the steps in this
section every time, follow steps 1 to 5 to open the Compatibility Checker, and then
click to select the Check Compatibility When Saving this Workbook check box.
Excel then checks for incompatible features automatically each time you save the
workbook. If it finds incompatible items, Excel displays the Compatibility Checker to let
you know. Note the problematic items and click Continue to save the document.