Microsoft Office Tutorials and References
In Depth Information
Version Compatibility
You see two types of problems reported in the Compatibility Checker:
Minor loss of fidelity
Minor loss of fidelity These issues involve formatting. If you
used a color beyond the pallet of 56 colors, it is reported as a minor
loss of fidelity. These types of issues are not considered serious.
The person using Excel 2002, Excel 2003, or Excel 2007 is allowed to
open the file, edit the file, and save the file.
Significant loss of functionality
Significant loss of functionality This means that you have used a
feature in Excel 2013 that no longer functions in legacy versions of
Excel. When you have these types of issues, the file opens in legacy
versions of Excel, but it is forced into a read-only state.
When you have an issue reported as a significant loss of functionality, you
can click the Find hyperlink. Excel closes the Compatibility Checker and
takes you to the area of the worksheet that contains the problem. If you
use this method, you constantly have to keep returning to the Compatibility
Checker to test other problems.
If many problems exist, click the Copy to New Sheet button. Excel inserts a
new Compatibility Report worksheet in the workbook. Each issue is listed,
along with a count of the number of issues and hyperlinks to help you find
the problem (see Figure 7.8 ).
Figure 7.8.
Figure 7.8. If you have many significant issues, it is easier to copy the con-
If you have many significant issues, it is easier to copy the con-
tents of the Compatibility Checker to a new worksheet.
tents of the Compatibility Checker to a new worksheet.
Search JabSto ::




Custom Search