[發問] 請問二進位活頁簿(.xlsb)的優點缺點？

Blade

Excel .xlsx 檔案越來越大，開啟的時間也越來越長久，如果把它轉了做二進位 .xlsb，速度快上了很多，請問二進位會不會有甚麼缺點？

sunnyso

回復 1# Blade

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

sorry typo, xlsb can support macros.

mhl9mhl9

把.xlsm另存為.xlsb,15Msize變為5Msize,開文件,關文件都快,用了幾天,一切都正常,至今我覺得沒有理由不把所有的.xlsm文件都儲存為.xlsb

flying008

xlsb二进制格式的确可以将同文件xlsx体积缩小不少, 开启速度也快多了.

ML089

如果 xlsb 檔案 size 較小，讀取速度應該是比較快，做為主資料庫檔案應該是不錯的選擇。

xls 相容性高，尤其雲端作業及查詢多，很多雲端公用程式都只支援xls(xlsx)， 作業後的資料表格還是用xls比較好做業

Blade

如果行巨集會不會有相容問題，文件只有136k。