Microsoft Office Tutorials and References
In Depth Information
Check for Features Not Supported by Earlier Excel Versions
Check for Features Not Supported
by Earlier Excel Versions
You can ensure that other people can view and
work with your Excel files by checking your
workbooks for features that are not compatible
with earlier versions of Excel.
Each new version of Excel includes many new
features, and some of these features introduce
functionality that is incompatible with earlier
versions of Excel. Examples of features new to
Excel 2010 that are incompatible with all
previous versions of Excel are sparklines,
slicers, and the new names that Excel 2010
uses for many existing statistical functions.
Other recent Excel features that are not
compatible with versions of Excel prior to
2007 are table styles, some cell styles, and
At best, these incompatible features can cause
your workbook to appear different to other
people; at worst, they can cause errors. If you
will be distributing a workbook to users of
earlier versions of Excel, use the Compatibility
Checker to look for incompatible features in
1 Open the workbook you
want to check.
2 Click the File tab.
3 Click Info.
4 Click Check for Issues.
5 Click Check Compatibility.