Large file size

  • Thread starter Thread starter MIKEISCONFUSED
  • Start date Start date
M

MIKEISCONFUSED

I have a worksheet in excel which has 11 columns and 15
rows. If I hightlight the columns and rows and paste
this worksheet into a new spreadsheet(values only) the
size of the file is 1.6 meg. This spreadsheet has some
visual basic code and some macros which someone other
than I wrote. Everytime the macro runs the file size
increases, yet I cannot determine how to decrease the
size of the file.
 
I think that the one thing that's easy to fix that makes the filesize smaller is
resetting the lastused cell on each worksheet.

Debra Dalgleish has some notes and pictures at:
http://www.contextures.com/xlfaqApp.html#Unused

If hitting ctrl-End takes you way past what you think should be the last cell,
you'll want to check it out.
 
Back
Top