My problem is two pronged. Firstly, I need to be able to
reduce the saved file size (approx 2.7mb) to facilitate
email distribution and website downloads, without losing
worksheets within my workbook, and without losing
formating (which is fairly extensive).

Secondly, various users have been getting not enough
memory errors. I understand that this is partially because
of Excel's 64mb heap space. What else may be causing these
errors, and how do I prevent them?

All advice would be appreciated

Thanks in advance.
Stuart Bazzard