Datasheet

22
11
22
33
44
55
66
The Save As dialog box
appears.
4 Select a location for the
new workbook.
5 Type a name for the new
workbook.
Note: Because the new workbook
will have a different file extension
(.xlsb), you do not need to change
the filename if you do not want to.
6 Click the Save As Type
drop-down arrow.
1 Open the workbook you
want to convert.
2 Click the File tab.
3 Click Save As.
If you have a large or complex Excel workbook,
you can make it open and save faster by
converting it to the Excel binary file format.
The standard file formats in Excel — Excel
Workbook and Excel Macro-Enabled
Workbook — are based on the OpenOffice
XML Standard, where XML is short for
eXtensible Markup Language. XML files are
really just complex text files that Excel reads
line-by-line when you open the file, and writes
line-by-line when you save the file. Excel has
been optimized to read and write XML code
extremely quickly, and so the standard Excel
file formats are fine for most worksheets.
However, if you have a worksheet that is very
large — for example, several thousand rows or
more, or several hundred columns or more —
or is very complex, then the standard file
formats may take a while to open and save. To
improve the performance of such files, you can
convert them to the Excel Binary Workbook
file format. This is identical to the Excel
Macro-Enabled Workbook format, except that
it uses binary code (which Excel can read and
write much faster) instead of XML code.
Make a Workbook Faster
by Saving it as Binary
03_577769-ch01.indd 2203_577769-ch01.indd 22 3/27/10 9:00 AM3/27/10 9:00 AM