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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Large File Size 3
dropdown boxes make file size too large 2
Size of file grows 4
File size 1
Excel 2003 Cell Comments causes large file size? 4
File Size 1
Need help on formatting row height 1
Macro/VB coding question 3

Back
Top