空的电子表格放在空间上 [英] Empty Spreadsheet holding onto space
问题描述
我的用户给了我一个电子表格，以研究我们的程序无法导入的原因。
My users gave me a spreadsheet to research why our program wasn't able to import.
- 我一直在慢慢剖析，至今已经删除了除了一个列之外的每一列和标签。
- 我已经选择并删除所有单元格，并确保没有隐藏。
- 我还检查了没有与该选项卡关联的代码。
然而，文件大小仍然是8兆！如果我创建一个新的标签，所以我可以删除原始的，然后缩小到几个。
And yet, the file size is still 8 megs! If I create a new tab so I can delete the original, it then shrinks to a few k.
其余的东西可以隐藏在标签中以保持这个大小？
Where else could something be hiding in the tab to keep that size?
推荐答案
UNTESTED！
非常大（字节）很少有明显的内容经常是通过数据转储到Excel中创建的。
Extraordinarily large (bytes) workbooks with very little apparent content are all too often created by data dumps into Excel.
一个原因可能是提取代码已经包含在数据中（检查 Developer， Visual Basic ）。
One reason can be that the extraction code has been included with the data (check Developer, Visual Basic).
更大的影响是格式化，可以通过编辑，查找&选择，转到特殊，最后一个单元格并观察突出显示的单元格距离上一个占用单元格很远。这可以修改如下：
More likely to have a significant size impact is formatting, that can be detected by Editing, Find & Select, Go To Special, Last cell and observing the highlighted cell is a long way from the last ‘occupied’ cell. This can be fixed as below:
- 选择最后一个占用行下方的行。
-
Ctrl + Shift + Down。 -
Del。 - 保存。
- Select row immediately below the last ‘occupied’ row.
Ctrl+Shift+Down.Del.- Save.
嵌入对象也可以增加大小（检查编辑，查找和选择，选择窗格）以及评论的内容，甚至不显示这些内容。 [这个问题的具体答案。]
Size may also be increased by embedded objects (check Editing, Find & Select, Selection Pane) and also the content of Comments even where these are not displayed. [The specific answer to this question.]
断开链接的数据透视表也可能是一个原因。
Pivot tables with broken links may also be a cause.
其他原因可能包括明显空白的最后一个单元格，确实被占用（使用字体颜色来匹配背景）或其他隐藏对象。
Other causes can include the likes of the apparently blank ‘last cell’ indeed being occupied (say with a font colour to match the background) or other hidden objects.
请注意在所有情况下，文件大小在保存之前可能不会减少删除。
Note that in all cases the file size may not reduce in response to ‘deletions’ until it is saved.
这篇关于空的电子表格放在空间上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
