269K-->Email It-->5MB!!!???

S

Scott McDonald

We have an excel worksheet with 13 tabs, a bunch of formula's etc that the file size is 269K total. When in the excel sheet, if we click to email it as the body of the email it sends it but it becomes 5MB's. Now I know office files have a tendency to grow past their actual size through modifying them, so we tried copying the content of this file into a new workbook/excel file - same problem.

Yet, we have another excel file, very similar one, that is 850K and emailed is only 1MB - we can't find a difference. Anyone have any ideas?


thanks,
 
D

David McRitchie

Hi Scott, you would want to zip the file and email it. With email
the file must be converted for transmission as character text, so
it would actually be better to put it on a web site and download
if from a link for a large file.

To keep the file size down, delete unused worksheets.
Check the last cell on the pages (ctrl+End).
http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell

If it is not feasible to put on your website, ....
Try zipping the file and attaching the zipped file rather using
mail this file and see if that helps. I had a 33MB that zipped to
13MB, but when sent it appeared in the email at just under 20MB.
Which I presume is due to making it compatible with email.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

We have an excel worksheet with 13 tabs, a bunch of formula's etc that the file size is 269K total. When in the excel sheet, if we
click to email it as the body of the email it sends it but it becomes 5MB's. Now I know office files have a tendency to grow past
their actual size through modifying them, so we tried copying the content of this file into a new workbook/excel file - same
problem.

Yet, we have another excel file, very similar one, that is 850K and emailed is only 1MB - we can't find a difference. Anyone have
any ideas?


thanks,
 
Top