excel file size problems

[kim]

I have an excel file that I've been working with for over a year -
developing Macros and running them to develop a product for my job on
a quarterly basis. My spreadsheet has grown by 10 times (1200kb to
12,000kb) over time, but I haven't added a lot of data. Can you help
me figure out the problem and fix it?

Thanks

 

[Faisal...]

It may be a problem with some blank cells in your spreadsheet. Try
deleting the unused rows after your data down to row 65500 and see
whether this reduces the size of your file.

Faisal...

 

[Otto Moehrbach]

To add to what Faisal says, on each sheet do the following. Scroll to what
you know to be the last used cell in the sheet. Note the cell address.
Now do Ctrl-End on your keyboard. That takes you to the cell that Excel is
using as the last used cell of your sheet. That cell, in part, determines
the size of your file.
If Excel's last used cell is vastly different than your last used cell, that
might explain the large file size.
To correct this, do this. Let's say that your (not Excel's) last used cell
is D100.
Select row 101. The whole row, not a cell in the row.
Do Ctrl-Shift-Down Arrow. This selects all the rows below your data. With
your mouse pointer in the selected area, right-click and click on Delete.
Then click on Column E. The column, not a cell in the column. Do
Ctrl-Shift-Right Arrow. As before, click on Delete.
Save the file.
Close the file.
See how large the file is.
HTH Otto

 

[Bill Renaud]

You might have to export all code modules, then delete them from the
workbook and compile and save the workbook to clean all the symbol tables.
Then re-import all code modules, re-compile, and save again.

There is a VBA code cleaner by Rob Bovey that could be used for this
purpose.
See http://www.appspro.com/Utilities/CodeCleaner.htm