Microsoft Office Tutorials and References
In Depth Information
The Excel File Format
Saving Files
Figure 14-16:
Using File Save
& Send, you can
email a copy of your
workbook , transfer
it to the Excel Web
App (page 867),
or upload it to
SharePoint (page
219). But ignore these
options for now and
focus on the File
Types section, which
gives you shortcuts
for saving your work
in alternative file
formats. If you click
Change File Type,
you get a list with
the most common
file formats (on the
right). Double-click
an entry to open the
Save As dialog box
with that selection.
The Excel File Format
Since time immemorial, Excel fans have been saving their lovingly crafted
spreadsheets in . xls files (as in AirlineSilverware.xls ). But when Excel 2007 hit the streets,
it introduced a completely new file format, with the extension . xlsx (as in
AirlineSilverware.xlsx ). Excel 2010 keeps the .xlsx revamped format, without introducing any
more changes.
As an Excel user, you need to decide whether you want to save your spreadsheets in
the latest and greatest .xlsx format or in the older .xls format. But before you make
that decision, it helps to know a bit more about the advantages of the .xlsx format:
It’s compact . The .xlsx format uses Zip file compression, so spreadsheet files
are smaller—way smaller (as much as 75 percent smaller than their original
sizes). And even though the average hard drive is already large enough to
swallow thousands of old-fashioned Excel files, the new compact format is easier to
email around.
It’s less error-prone . The .xlsx format carefully separates ordinary content,
pictures, and macro code into separate sections. Microsoft claims that this change
makes for tougher files. Now, if a part of your Excel file is damaged (for
example, due to a faulty hard drive), there’s a much better chance that you can still
retrieve the rest of the information. (You’ll learn about Excel disaster recovery
on page 380.)
Search JabSto ::

Custom Search