Excel file grew without explanation to 12mb?!

[Warren Tranquada]

I have a very simple excel file - litterally just a
column of numbers to add (maybe 20 numbers), on 4
worksheets, and a few titles (nothing fancy). There are
three sum functions and that is it. No graphics, no
macros, no links, no advanced functions.

For some reason the file is 12mb so it can't be e-mailed.
Any ideas on what happened, how to trouble-shoot it, or
what to do to get it to a reasonable size? There is no
reason I can think of for this file to be larger than
100k.

 

[slarson]

Warren,

Try going to View\Page Break Preview. Drag the blue
dividers into place for the sheet of data you have. Return
to normal view and save. Your file should be to the size
it needs to be.

 

[Dave Peterson]

Sometimes you can underestimate the lastused cell in a worksheet. If you hit
ctrl-End, does it take you way past what you expected?

If yes, then Debra Dalgleish has some t

 

[Warren Tranquada]

Thank you. File was reduced from 12mb to 20kb.

-----Original Message-----
Sometimes you can underestimate the lastused cell in a worksheet. If you hit
ctrl-End, does it take you way past what you expected?

If yes, then Debra Dalgleish has notes at:
http://www.contextures.com/xlfaqApp.html#Unused
that may help.



--

Dave Peterson
(e-mail address removed)
.