Microsoft Office Tutorials and References
In Depth Information
Make a Workbook Faster by Saving it as Binary
Make a Workbook Faster
by Saving it as Binary
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.
1 Open the workbook you
want to convert.
2 Click the File tab.
3 Click Save As.
The Save As dialog box
4 Select a location for the
5 Type a name for the new
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