ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý¤G¶i¦ì¬¡­¶Ã¯(.xlsb)ªºÀuÂI¯ÊÂI¡H

[µo°Ý] ½Ð°Ý¤G¶i¦ì¬¡­¶Ã¯(.xlsb)ªºÀuÂI¯ÊÂI¡H

Excel .xlsx Àɮ׶V¨Ó¶V¤j¡A¶}±Òªº®É¶¡¤]¶V¨Ó¶Vªø¤[¡A¦pªG§â¥¦Âà¤F°µ¤G¶i¦ì .xlsb¡A³t«×§Ö¤W¤F«Ü¦h¡A½Ð°Ý¤G¶i¦ì·|¤£·|¦³¬Æ»ò¯ÊÂI¡H

¦^´_ 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
ss

TOP

sorry typo, xlsb can support macros.
ss

TOP

§â.xlsm¥t¦s¬°.xlsb,15MsizeÅܬ°5Msize,¶}¤å¥ó,Ãö¤å¥ó³£§Ö,¥Î¤F´X¤Ñ,¤@¤Á³£¥¿±`,¦Ü¤µ§Úı±o¨S¦³²z¥Ñ¤£§â©Ò¦³ªº.xlsm¤å¥ó³£Àx¦s¬°.xlsb
lmh

TOP

xlsb¤G进¨î®æ¦¡ªºÚÌ¥i¥H将¦P¤å¥óxlsxÊ^积缩¤p¤£¤Ö, 开启³t«×¤]§Ö¦h¤F.
¥u¦³·Q¤£¨ìªº,
没¦³°µ¤£¨ìªº.

TOP

¦pªG xlsb ÀÉ®× size ¸û¤p¡AŪ¨ú³t«×À³¸Ó¬O¤ñ¸û§Ö¡A°µ¬°¥D¸ê®Æ®wÀÉ®×À³¸Ó¬O¤£¿ùªº¿ï¾Ü¡C

xls ¬Û®e©Ê°ª¡A¤×¨ä¶³ºÝ§@·~¤Î¬d¸ß¦h¡A«Ü¦h¶³ºÝ¤½¥Îµ{¦¡³£¥u¤ä´©xls(xlsx)¡A §@·~«áªº¸ê®Æªí®æÁÙ¬O¥Îxls¤ñ¸û¦n°µ·~
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦pªG¦æ¥¨¶°·|¤£·|¦³¬Û®e°ÝÃD¡A¤å¥ó¥u¦³136k¡C

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD