Excel File getting bigger

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
You could try:

Edit|goto|special|check objects
if any are found, hit the delete key on the keyboard.
 
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.
Click to expand...
 
Back
Top