Excel file grew without explanation to 12mb?!

  • Thread starter Thread starter Warren Tranquada
  • Start date Start date
W

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.
 
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.
 
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
 
Back
Top