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

  • Thread starter Thread starter Scott McDonald
  • Start date Start date
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,
 
It kind of sounds like you're not sending it as an attachment, but as the body.

If you click File|Sendto|Mail Recipient (as attachment), what size does it
become?

(I'm guessing that when you send it as the body, xl has to convert it to that
HTML stuff--and who knows how much that takes????)
 
that's the problem though, it is being sent as the body but other documents,
similar to it, do not have this problem...?
 
I don't use this--I'd rather send a real workbook.

But maybe excel takes more of that HTML stuff to look pretty.

Scott said:
that's the problem though, it is being sent as the body but other documents,
similar to it, do not have this problem...?
Click to expand...
 
I also wish they wouldn't do it, and I've tried talking the CEO out of
having everyone do it - that's a no go so I need to somehow figure out why
all other excel docs email at roughly the same size (usually about 25%
bigger) and why this particular one is about 10 times bigger
 
more cells used?
more formats used?
more objects (pictures/buttons/etc) used?

(good luck!)

Scott said:
I also wish they wouldn't do it, and I've tried talking the CEO out of
having everyone do it - that's a no go so I need to somehow figure out why
all other excel docs email at roughly the same size (usually about 25%
bigger) and why this particular one is about 10 times bigger
Click to expand...
 
Maybe the used range is too far down to the right (hit ctrl-end and see where
that takes the user).

If it's way past where your data ends, you could try some of the techniques at
Debra Dalgleish's site to reset that bottom right cell:

http://www.contextures.com/xlfaqApp.html#Unused

(But I don't have too much faith that this is the solution.)

Scott said:
actually less of all of that...Crap, I'm screwed.
Click to expand...
 
Back
Top