Microsoft Office Tutorials and References
In Depth Information
Saving Your Spreadsheet for Excel 2003
Saving Files
4. Reviewtheproblems.
You can choose to ignore the Compatibility Checker issues, click Find to hunt
each one down, or click Help to figure out the exact problem. You can also click
Copy to New Sheet to insert a full compatibility report into your spreadsheet as
a separate worksheet. This way, you can print it up and review it in the comfort
of your cubicle. (To get back to the worksheet with your data, click the Sheet1
tab at the bottom of the window.)
Note: The problems that the Compatibility Checker finds won’t cause serious errors, like crashing your
computer or corrupting your data. That’s because Excel is designed to degrade gracefully . That means you
can still open a spreadsheet that uses newer, unsupported features in an old version of Excel. However,
you may receive a warning message and part of the spreadsheet may seem broken—that is, it won’t work
as you intended.
5. Optionally,you can set theCompatibilityChecker to runautomatically for
Turn on the “Check compatibility when saving this workbook” checkbox. Now,
the Compatibility Checker will run each time you save your spreadsheet, just
before the file is updated.
Saving Your Spreadsheet for Excel 2003
If you want to share your workbook with people who are using Excel 2003, the process
is a bit more involved, because Excel 2003 uses the older .xls format instead of .xlsx.
When you find yourself in this situation, you have two choices:
Save your spreadsheet in the old format . You can save a copy of your
spreadsheet in the traditional .xls Excel standard that’s been supported since Excel 97.
To do so, choose File Save As, and then, from the “Save as type” list, choose
Excel 97-2003 Workbook.
Use a free add-in for older versions of Excel . People who are stuck with Excel
2000, Excel 2002, or Excel 2003 can read your Excel 2010 files—they just need
a free add-in that’s provided by Microsoft. This is a good solution because it’s
doesn’t require any work on your part. People with past-its-prime versions of
Excel can find the add-in they need by surfing to
and searching for “compatibility pack file formats” (or use the shortcut http:// ). However, you should still run the Compatibility Checker
(page 373) to find out if your spreadsheet uses features that aren’t supported in
Excel 2003.
Tip: When you save your Excel spreadsheet in another format, make sure you keep a copy in the
standard .xlsx format. Why bother? Because other formats aren’t guaranteed to retain all your information,
particularly if you choose a format that doesn’t support some of Excel’s newer features.
Search JabSto ::

Custom Search