the binary file format (biff12) for excel 2010 and excel 2007. stores vba macro code or excel 4.0 macro sheets (.xlm). The xml based and macro enabled file format for excel 2016, excel 2013, excel 2010, and excel 2007.
1 7: understand common excel file formats (xlsx, xlsm, xlsb, xls, pdf) video duration: 05:23. the main difference: binary files are computer but not human readable. instead, xlsb files try to save disk space because the data is stored in the binary structure. Xlsb files store the data a little bit different than the xlsx or xlsm file types: they don’t use the xlm file structure. How to use common excel file formats including xlsx excel workbook (or open xml format), xlsm excel macro enabled workbook, xls exworkbook, xlsb.
