唔知點解size會咁大(1450KB)
i would like to ask
(q1)
有什麼原因會令xls file咁大?
(q2)
我可以由那裡找到reason to know? (i received this file from other)
thank you.
更新1:
excel會記下很多多餘的東西在file內。size會越來越大。 (q3) 我可以係那裡delete 這些多餘的record?
excel file, size 大
2010-06-01 6:09 pm
有一個xls file, 但只有data (a1:h142), 無graph,
唔知點解size會咁大(1450KB)
i would like to ask
(q1)
有什麼原因會令xls file咁大?
(q2)
我可以由那裡找到reason to know? (i received this file from other)
thank you.
唔知點解size會咁大(1450KB)
i would like to ask
(q1)
有什麼原因會令xls file咁大?
(q2)
我可以由那裡找到reason to know? (i received this file from other)
thank you.
回答 (2)
2010-06-01 6:30 pm
✔ 最佳答案
通常是一些千年file，就是說同一個file被人常期剪剪貼貼幾百次後，excel會記下很多多餘的東西在file內。size會越來越大。把他另存為其他格式（html），再存回excel就可以收身。
2010-06-01 14:36:13 補充：
人肉delete唔到，人眼也見唔到。或者有其他方法，但我的方法就是先存成html,再存回excel。
2010-06-01 11:54 pm
你可以試試新開一個空白的excel 活頁簿,
把原本的excel 內容copy & paste到新的活頁簿,
然後save.
file size 應該會減少.
把原本的excel 內容copy & paste到新的活頁簿,
然後save.
file size 應該會減少.
收錄日期: 2021-04-19 22:24:27
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100601000051KK00277