P
paulfj
I've been using a spreadsheet with a bunch of macros in Excel 2003 for
a couple years, and all was well until we started using 2007. The file
is typically about 1MB at its beginning, and normally grows to about
1.4MB as it's filled out.
However, in 2007 the file size increases to over 2MB with one revision
made via a macro (and save), then 4MB, then 11, then 27. You get the
picture.
I'm not sure how to get around this. When I save this as a 2007 macro-
enabled workbook, the file size seems to stay manageable, but I run
into errors with my code.
I would prefer a solution to the size problem that doesn't involve a
complete overhaul of my code or, worse, recreating the code in 2007.
a couple years, and all was well until we started using 2007. The file
is typically about 1MB at its beginning, and normally grows to about
1.4MB as it's filled out.
However, in 2007 the file size increases to over 2MB with one revision
made via a macro (and save), then 4MB, then 11, then 27. You get the
picture.
I'm not sure how to get around this. When I save this as a 2007 macro-
enabled workbook, the file size seems to stay manageable, but I run
into errors with my code.
I would prefer a solution to the size problem that doesn't involve a
complete overhaul of my code or, worse, recreating the code in 2007.