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
"kim" wrote in message
ups.com...
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