I have an application built in Excel 2003 with user forms and numerous
macros. For years this worked fine and maintained a file size of
1.2MB. Then our company shifted to Excel 2007, and after I tweaked
some of the macros while in Excel 2007, and when I saved the file the
size exploded to 10 times the original size...11.2MB !!!

I think I narrowed it down to changing a Sort macro. I recorded this
Sort macro in Excel 2007 and saved it and that's when the file size
grew so much.

Again, when I tweaked the Sort macro on a machine running with Excel
2003 it works and the size remains at 1.2MB, it's just when I change
the macro in 2007 and save it there does it mushroom.


Can anyone shed some light on this?

Is there anything I can do to prevent the file getting so big.

TIA