Saving as Binary - PLEASE?? Clarification

  • Thread starter Thread starter Kevryl
  • Start date Start date
K

Kevryl

This question concerns Excel 2007

(Thanks to Peter Foldes in "Office General Questions" for pointing out this
missing information)
=======================================


This is my 4th attempt to get an answer: I posted this question in Excel
General Questions on 29th March, and on 20th May and inadvertently to "Office
General Questions" yesterday - no reply from any as yet. It surely is a
basic question for
some of the MVP boffins in here: Surely ... someone MUST know the answer??

Here we go:

If binary is more efficient speed and space-wise, why isn't it the default
format for saving? (or read "the best way to save a file)?

I'm trying to find out what the downside is before I save a majorly
important, large file with heaps of macros in binary and start moving on
with it to find a little way down the track I've made a terrible mistake! If
it isn't the default there must be a reason - a down side - but I can't find
anything in Help to tell me.

Anyone know?
 
Myself is a learner and I am not sure whether this is what you are looking for…
Anyway I hope this may help you…

Some Hints:-

Users also can set their desired file format as default in Excel 2007. If
you want to set the Default File Saving Format to .xlsb then Click the Office
Ribbon Button(colorful round circle at the top Left
corner)>Excel Options>Save>Save Workbooks>Save Files in this format>Select
Excel Binary Workbook from the Drop Down and press Ok…

New Excel 2007 formats
Format Extension Description
Excel Workbook [.xlsx] The default Excel 2007 workbook format. In reality a
ZIP compressed archive with a directory structure of XML text documents.
Functions as the primary replacement for the former binary .xls format,
although it does not support Excel macros for security reasons.
Excel Macro-enabled Workbook [.xlsm] As Excel Workbook, but with macro
support.
Excel Binary Workbook [.xlsb] As Excel Macro-enabled Workbook, but storing
information in binary form rather than XML documents for opening and saving
documents more quickly and efficiently. Intended especially for very large
documents with tens of thousands of rows, and/or several hundreds of columns.
Excel Macro-enabled Template [.xltm] A template document that forms a basis
for actual workbooks, with macro support. The replacement for the old .xlt
format.
Excel Add-in [.xlam] Excel add-in to add extra functionality and tools.
Inherent macro support because of the file purpose.

Remember to Click Yes, if this post helps!
 
Thanks for that, but still wondering what the downaside might be of saving in
binary :-)

Ms-Exl-Learner said:
Myself is a learner and I am not sure whether this is what you are looking for…
Anyway I hope this may help you…

Some Hints:-

Users also can set their desired file format as default in Excel 2007. If
you want to set the Default File Saving Format to .xlsb then Click the Office
Ribbon Button(colorful round circle at the top Left
corner)>Excel Options>Save>Save Workbooks>Save Files in this format>Select
Excel Binary Workbook from the Drop Down and press Ok…

New Excel 2007 formats
Format Extension Description
Excel Workbook [.xlsx] The default Excel 2007 workbook format. In reality a
ZIP compressed archive with a directory structure of XML text documents.
Functions as the primary replacement for the former binary .xls format,
although it does not support Excel macros for security reasons.
Excel Macro-enabled Workbook [.xlsm] As Excel Workbook, but with macro
support.
Excel Binary Workbook [.xlsb] As Excel Macro-enabled Workbook, but storing
information in binary form rather than XML documents for opening and saving
documents more quickly and efficiently. Intended especially for very large
documents with tens of thousands of rows, and/or several hundreds of columns.
Excel Macro-enabled Template [.xltm] A template document that forms a basis
for actual workbooks, with macro support. The replacement for the old .xlt
format.
Excel Add-in [.xlam] Excel add-in to add extra functionality and tools.
Inherent macro support because of the file purpose.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


Kevryl said:
This question concerns Excel 2007

(Thanks to Peter Foldes in "Office General Questions" for pointing out this
missing information)
=======================================


This is my 4th attempt to get an answer: I posted this question in Excel
General Questions on 29th March, and on 20th May and inadvertently to "Office
General Questions" yesterday - no reply from any as yet. It surely is a
basic question for
some of the MVP boffins in here: Surely ... someone MUST know the answer??

Here we go:

If binary is more efficient speed and space-wise, why isn't it the default
format for saving? (or read "the best way to save a file)?

I'm trying to find out what the downside is before I save a majorly
important, large file with heaps of macros in binary and start moving on
with it to find a little way down the track I've made a terrible mistake! If
it isn't the default there must be a reason - a down side - but I can't find
anything in Help to tell me.

Anyone know?
Click to expand...
Click to expand...
 
Back
Top