Workbook over 1M, but empty?!

  • Thread starter Thread starter soundneedle
  • Start date Start date
S

soundneedle

I copied a populated worksheet into a new, blank workbook. I then
selected all cells in the new worksheet and deleted. I also reset the
last used row. No data, no hidden sheets, no macros...no code behind
the book or sheet.
So, why is the seemingly blank new workbook just over 1MB in size?
 
Did you double check the lastused cell position by hitting ctrl-end (on each
worksheet)?

Did you add any objects (pictures/buttons/etc)?

(I'm betting that ctrl-End still takes you far away from A1.)
 
Norman, I had already reset the last used row/cell. But, I tried the
methods as provided in your hyperlink. The file size remains unchanged
at about 1MB. Very bizzare....maybe some sort of excel bug.
 
Dave, ctrl-end takes me to I1, when the active cell is A1. There are no
objects...no VB code, modules, forms, etc.
 
Just to check for invisible shapes:

Option Explicit
Sub testme()
Dim myShape As Shape
With ActiveSheet
MsgBox .Shapes.Count
For Each myShape In .Shapes
myShape.Visible = True
'MsgBox myShape.TopLeftCell.Address
Next myShape
End With
End Sub

No comments, no nothing.

Now my bet is on invisible shapes! <I'm not much of a horse player.>
 
Hi SoundNeedle,

In your original post you say:
I copied a populated worksheet into a new, blank workbook. I then
selected all cells in the new worksheet and deleted.
Click to expand...

Out of curiosity, and perhaps because it will expose my misunderstanding of
the problem, why? At first blush, that seems an energetic way of doing
nothing!

If you are sure that none of the sheets contains any data (i.e hitting
Ctrl-End in each sheet
leaves you in A1) and that no there are no code bearing modules, I am
stumped.
 
Hi Dave,
Just to check for invisible shapes:
Click to expand...

Now that is an idea!

As Sherlock Holmes once said:

"How often have I said to you that when you have eliminated the impossible,
whatever remains, however improbable, must be the truth?
 
See if there are any defined names which may be the culprit!
Bob Umlas
Excel MVP

I'm leading a FREE 1-hour online Webinar on Excel Tips & Tricks.
Dec 16, Jan 14, Jan 27 from 4-5PM (each session is the same).
If interested, go to http://www.iil.com, click on the yellow/orange
"Try a free webinar" link on the left side, click the Microsoft Excel
Tips & Tricks link, follow instructions to register.
 
(Hope this only got posted once...)

Bob, you've solved the problem. There were several named ranges...over
50. Some of the ranges were external file references; however, the
workbook didn't have any external links.

Why would named ranges in an "empty" workbook cause such file-size
bloating?
 
Bob, you've solved the problem. There were several named ranges...over
50. Some of the ranges were external file references; however, the
workbook didn't have any external links.

Why would named ranges in an "empty" workbook cause such file-size
bloating?
 
I've been watching this thread to see if any of it applies to a similar
incident that I had recently.

A user emailed a spreadsheet to me that was nearly 3 megs. When I opened
it, I certainly didn't think there was 3 megs of stuff there. I saved it on
my machine to investigate it further, but after I saved it the size was less
than 40K.

The user was using XL97 and I have XL2002, both using W2K.

I wish I had kept it to look for some of the things mentioned in this
thread. But if they were there, wouldn't the file size stay the same when I
saved it?

Any ideas anyone?

Carlos
 
I would guess that the offending stuff would stay until you did something to get
rid of it.

I have a routine to reset the last used cell assigned to a shortcut key. I run
it lots without thinking. Maybe you did something (deleting rows/columns) that
did the same thing.

Maybe you could ask for a second copy and experiment on that???
 
Back
Top