Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XLSX vs XLSB - what format is preferably and when?
See this page for a more complete discussion:
http://blogs.msdn.com/excel/archive/...20/671995.aspx Primarily you'll note that the difference is whether or not a file CAN contain macros or not. An .xlsx file cannot (but .xlsm can) while .xlsb can contain macros, but of course doesn't have to. Bottom line is that as long as all users have Excel 2007, the .xlsb format is probably the most efficient way to go. "Andrey Son" wrote: Hello. New Excel 2007 / Excel:2008 supports new formats - XLSX and XLSB. As noticed in documentation, XLSB is variation of XLSX but binary format used to store the date therefore XLSB files are smaller in size and faster to load/save. No any other differences ware founed by me between this two formats. My question is - when it's preferably to use XLSX and it's prefer to use XLSB? It's seems to me XLSB is better by all and it's not needed to use XLSX, but XLSX was choosed as default Excel 2007 format and this fact must have a reason. What are the main cases to use XLSX and what are for XLSB? Than you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
XLSX vs XLSB - what format is preferably and when?
Thank you very much.
The only plus of XLSX format is that my iPhone "Files lite" application can display XLSX files and can not display XLSB. From you reply it's clear than XLSB format is more functional and more preferred to use if there are no any conditions to prohibit it. "JLatham" wrote: Bottom line is that as long as all users have Excel 2007, the .xlsb format is probably the most efficient way to go. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
XLSX vs XLSB - what format is preferably and when?
Hi Andrey
Code that use ADO have problems with xlsb files so I use xlsm by default because i use a lot of code in my workbooks. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Andrey Son" wrote in message ... Thank you very much. The only plus of XLSX format is that my iPhone "Files lite" application can display XLSX files and can not display XLSB. From you reply it's clear than XLSB format is more functional and more preferred to use if there are no any conditions to prohibit it. "JLatham" wrote: Bottom line is that as long as all users have Excel 2007, the .xlsb format is probably the most efficient way to go. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
XLSX vs XLSB - what format is preferably and when?
One more fact that XLSB is more suitable as standalone data file for
Excel-use only, but XLSX is better for use in programming and Excel-data processing usinn any external programming interfaces. "Ron de Bruin" wrote: Hi Andrey Code that use ADO have problems with xlsb files so I use xlsm by default because i use a lot of code in my workbooks. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to default file save format to .xlsx in Excel? | Excel Discussion (Misc queries) | |||
How do I set default Excel Saveas file format to xlsx not xlsx | Setting up and Configuration of Excel | |||
Substituting a xls format with a xlsx format file | New Users to Excel | |||
how to download excel help preferably in the form of chm? | New Users to Excel | |||
How to open a Template under a different name, preferably the dat | New Users to Excel |