xlsb is a binary file format, it is very fast and dramatically reduces file size as you have found out. It does have limitations however though these may well not impact you, firstly it cannot support macros, only xlsm can and secondly it cannot be read by other software. Excel has long been used as an input format for various applications, these won't be able to read xlsb. You could however save your xlsb as xlsx/xls if this is an issue though.
I always use xlsb unless there is a specific reason why I can't, in my case usually macros作者: sunnyso 時間: 2013-5-23 20:50
sorry typo, xlsb can support macros.作者: mhl9mhl9 時間: 2013-7-15 20:55
