Two ideas...

1. Do you have any Pivot Tables in this workbook? I have seen my file size
grows considerably with a Pivot. If so, you can copy the data out of the
pivot into a standard table and remove the pivot to free up a considerable
amount of space.

2. The only other idea might be formatting. Are the spreadsheets formatted
all the way over or all the way down for any reason. I have seen this make a
workbook much larger than it should be. Try deleting all blank rows and
columns and resaving it. The rows and columns should rebuild themselves with
NO formatting (freeing up a lot of memory for the workbook).

Just my thoughts...

Mark Ivey


"Sam" wrote in message
...
I have an excel app with a lot of vba and a lot of formulas. It has always
been around 10MB but after adding much more vba functionality (UserForms
and
code mostly) it has grown by about 5MB. Many of the worksheets go past row
5000, even when I select all cells below row 200 for all columns and
delete
(shift up & left). How can I reduce the file size? What components make up
file size other than data? Is there a way to evaluate these components?

Thanks