I'm not sure if it will help you, but it definitely helped me. I found
a program that shrinks Excel file sizes. The reasoning they gave was
that for some reason while creating a sheet, it redundantly saves
formulas and data that you previously deleted or something. Anyhow, I
went from a 10mb file to a 3mb file. Then i shrunk it again to see if
it would shrink again. It went to 600k. I couldn't shrink it anymore
then that. I don't quite remember the name of the program, but if you
google "Excel file shrink" or something like that, you're bound to
find it or something similar.
Is there something that I can do to the front end of the file w/o using vb
code?