Bruce,

I did an experiment where I created 6 sheets with a 36x45 block of data + a
header. This came out to 81kb. I then took the same data and pasted it into a
new workbook all on the same sheet and delted sheets 2 and 3. No difference,
still 81kb. I then zipped it up with winzip and got a 95% compression ratio,
i.e., a 5kb file size. If you haven't been zipping, that will be a big help.
It doesn't sound like your indivdual sheets are overly complex, so I'm not
sure that you can reduce much. Hard to say without seeing your formulas and
so forth.

Roy



"Bruce" wrote:

Wondering if any of you have any suggestions for decreasing the file size for
a workbook. Granted it has a LOT of sheets (aka tabs) (about 210), but not a
lot of info and it grows in 2MB increments it seems - 45 rows to a sheet, 36
columns, a third of which are blank, and a third are numeric entries, the
other third formulas.

It is getting a bit unwielding to e-mail around and I am looking for ideas
on how I can decrease the size of it.

Thanks for any thoughts you may have.
--
Bruce