File Size

[JMW]

I have an Excel 2003 file which was about 2MB in size running various array
formulae across a range of data. Having recently added one more sheet with
formulae that are actually less complex than the other 10 or so sheets, the
file size has increased to 7MB. Why would it do this and how can I get the
file size back down closer to 2MB again?! Thanks.

 

[Kevin B]

You might have unused lines in each of the worksheets that have been
previously formatted but are not in use. The following URL has information
on removing unused lines from the worksheets in a workbook. There's a manual
version and a macro driven version.

http://www.contextures.com/xlfaqApp.html#Unused