Help, file bloat

How can I get my Excel file size down? Is there a setting or that will set the number of columns and rows? I tried deleting them but there are sooo many.

Feel free to email directly (remove ones).

Tom
TMiller1@MBHomes1.com

send me the file and i'll have a look.
u cannot lower the file size by deleting already empty cells. if no style is
applied to a cell, it does not counts a byte. (serdarsoy1@1hotmail.com)
(remove 1's



"Tom@mb" <Tommb.1yyeny_1132756203.6479@excelforum-nospam.com>, haber
iletisinde şunları
yazdı:Tommb.1yyeny_1132756203.6479@excelforum-nospam.com...
>
> How can I get my Excel file size down? Is there a setting or that will
> set the number of columns and rows? I tried deleting them but there are
> sooo many.
>
> Feel free to email directly (remove ones).
>
> Tom
> TMiller1@MBHomes1.com
>
>
>
> --
> Tom@mb
> ------------------------------------------------------------------------
> Tom@mb's Profile:
> http://www.excelforum.com/member.php...o&userid=29034
> View this thread: http://www.excelforum.com/showthread...hreadid=487630
>

Hi Tom,

See Debra Dalgleish's detailed instructions on resetting the used range:

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

---
Regards,
Norman


"Tom@mb" <Tommb.1yyeny_1132756203.6479@excelforum-nospam.com> wrote in
message news:Tommb.1yyeny_1132756203.6479@excelforum-nospam.com...
>
> How can I get my Excel file size down? Is there a setting or that will
> set the number of columns and rows? I tried deleting them but there are
> sooo many.
>
> Feel free to email directly (remove ones).
>
> Tom
> TMiller1@MBHomes1.com
>
>
>
> --
> Tom@mb
> ------------------------------------------------------------------------
> Tom@mb's Profile:
> http://www.excelforum.com/member.php...o&userid=29034
> View this thread: http://www.excelforum.com/showthread...hreadid=487630
>

You can hide the unwanted rows and columns. Or, you can color them all black.


To reduce the megabyte count of the file size you can use the Save As feature, instead of a simple Save, and save the file as the existing file name. This works because to some extent, for speed, when you update a file Excel simply saves the changes in its internal format, so with each simple Save the file size grows. The Save As undoes this, saving only the most recent version.

There are limits to the cycle of saving only the changes. At some point Excel will effectively do a Save As anyway, but you can force the matter as described.