Excel File getting bigger
 

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

Excel File getting bigger
 

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?

jim28 wrote:

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

Excel File getting bigger
 

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" wrote:

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?

jim28 wrote:

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

Excel File getting bigger
 

You could try:

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

jim28 wrote:

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" wrote:

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?

jim28 wrote:

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


--

Dave Peterson

Excel File getting bigger
 

I try it, however, no object inside.

"Dave Peterson" wrote:

You could try:

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

jim28 wrote:

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" wrote:

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?

jim28 wrote:

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


--

Dave Peterson

Excel File getting bigger
 

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

jim28 wrote:

I try it, however, no object inside.

"Dave Peterson" wrote:

You could try:

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

jim28 wrote:

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" wrote:

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?

jim28 wrote:

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


--

Dave Peterson


--

Dave Peterson