Excel File Size

**warrior2411** · 01-20-2013, 06:42 PM

I am trying to send an attachment to coworkers with a macro-enabled Excel file through Outlook 2010. Every time I try to attach the file in Outlook, I keep receiving "The Attachment Size Exceeds The Allowable Limit" message. There are two issues:

1) I created a similar document recently, which is only about 2,000 KB. However, this document only has a few more tabs/functions is 28,421 KB. I don't know why it's so much larger?

2) I need to keep my macros enabled, is there anyway to compress the file to sustain the current macros while being able to successfully attach/email the file?

I need to send this document yesterday...any and all help is much appreciated!

**Richard Buttrey** · 01-20-2013, 06:49 PM

Hi,

Often files get bigger when formulae are accidentally copied to the last row of a sheet. Check with End Home on each sheet to see if this is the case and if so delete all surplus rows.

Saving the file as a .xlsb file will make it smaller than an .xlsm file size but that's about the best compression you can get.

Hope this helps

**FDibbins** · 01-20-2013, 06:51 PM

Check that you do not have any un-used cells or formatting in the workbook.

1 way to do that, is on each sheet to hit END HOME and see where it takes you. If you end up in the middle of "no-where" you have rows and/or columns that have something in them. If you are SURE that the extra rows and/or columns do not contain any data, delete those rows and columns back to the bottom-right corner of the furthest range.

Also, remove any unnecessary formatting. Conditional Formatting in particular can eat up file space

**warrior2411** · 01-20-2013, 08:34 PM

I greatly appreciate both of your suggestions! Richard Buttrey, I pressed 'CTRL' & 'down' and deleted everything up to my used cells. Likewise, I pressed 'CTRL' & 'right' and deleted everything left to my used cells. Somehow, I shrunk the size to 256 KB! Thanks again for your quick help!!!