Microsoft Office Tutorials and References
In Depth Information
Version Compatibility
Version Compatibility
With not just one new file format but three file formats in Excel 2013, you
face a number of problems as you try to share files with people who use leg-
acy versions of Excel.
If you are using Excel 2013 and want to open a file created in Excel 5 through
Excel 2003, your copy of Excel gladly opens the file, but the file is in a spe-
cial Compatibility mode. In this mode, you cannot use more than 65,536 rows,
and you cannot use more than 256 columns. When you attempt to save the file,
the Compatibility Checker tells you what functionality will be lost.
If you start with a new spreadsheet in Excel 2013 and want to share the file
with someone using Excel 5, 95, 97, or 2000, you have to use the Compatibility
Checker and save the file in a legacy version of Excel.
If you start with a new spreadsheet in Excel 2013 and want to share the file
with someone using Excel 2002 or Excel 2003, you can encourage that person
to download the Compatibility Pack for the Microsoft Office system. This
converter allows Excel 2002 and Excel 2003 to open files stored in the new
XLSB, XLSM, and XLSX formats.
However, before you send the file, you should run it through the Compatibil-
ity Checker. To do so, follow these steps:
11. With the file open, go to the File tab in the ribbon. Excel opens in
Backstage view.
22. Along the left navigation, select Info.
33. In the middle of the center pane, open the Check for Issues drop-down.
44. Select Check Compatibility. Excel displays the Compatibility Check-
er, as shown in Figure 7.7 .
Search JabSto ::




Custom Search