Excel File getting bigger

[Guest]

Hi,

I found that Excel file getting bigger. So I try to test it by delete and
remain only one worksheet and no formula or number inside. The file size
still have 170K. Do you have any ideas what is still inside the excel file
but they are hidden? How can I remove those items?

Please note that I have already delete all the names and Macro inside the
file, but still have no cue what is remain

 

[Dave Peterson]

Have you tried to reset the last used cell?

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

Any chance you've added shapes/pictures/controls to the worksheet?

 

[Guest]

Yes, I have try it, however, file size remain the same.

I don't think there is any shapes/picture/control. However, I don't know why
there are still some stuffs hidden that I did not know. Also, Excel did not
provide some convenient way to delete those stuffs.

Thank you Dave, if you have more ideas to test it and find them, let me
know. Thanks.

 

[Dave Peterson]

You could try:

Edit|goto|special|check objects
if any are found, hit the delete key on the keyboard.

 

[Guest]

I try it, however, no object inside.

You could try:

Edit|goto|special|check objects
if any are found, hit the delete key on the keyboard.

 

[Dave Peterson]

Any chance that they're hidden shapes?

Option Explicit
Sub testme()
Dim wks As Worksheet
Dim shp As Shape

For Each wks In ActiveWorkbook.Worksheets
MsgBox wks.Name & " has: " & wks.Shapes.Count & " shapes."
For Each shp In wks.Shapes
'shp.Delete
MsgBox shp.Name
Next shp
Next wks
End Sub


Do you have lots of comments?

Any chance you've added a background: Format|sheet|background

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

I try it, however, no object inside.