Reducing File Size???

[Jio.]

I have the same file performing the exactly the same thing
but one is double the other. It appears to me that the
more I work with the worksheet the bigger the size of the
file. how can I remove this redundant memory space?

Cheers

 

[John Wilson]

Jio,

You probably have formatted or otherwise used some rows below or
columns to the right of your data. On the bloated workbook, select the
sheets individually and press Ctrl + End. If the last row and column
is well below where you think it should be, you'll need to delete the
empty rows and columns.

Check here for an example of how to do this both manually
and with VBA:

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

John