ExcelBanter - File size getting large

Hi Halim, (excel.programming)
I don't have Excel 2003, so it may have unique problems, and likewise
don't work on a network.

One possible problem and one that has a solution is an
error in the Last Cell indication of worksheet(s) -- see what
you get with Ctrl+End which should be at the intersection of your
last used row and column.

If that is the problem, you are possibly either adding and deleting a lot of rows,
or unnecessarily processing cells with a macro and doing something
to them.

You can fix the problem for a single sheet by placing the cursor
on the cell that you want to be the cell then running the macro.
There is a test to see if the last cell would be in a merged cell and
will adjust accordingly, you will be doing this while looking at the data
so should be safe. (last updated 2006-07-05 for merged cells)
http://www.mvps.org/dmcritchie/excel...m#makelastcell

You can correct all the sheets in your workbook with a macro by
Debra Dalgleish -- Warning if the last cell is within a merged cell
on a sheet you will lose data.
to programmatically reset the last used cell (all sheets)
http://www.contextures.com/xlfaqApp.html#Unused

You might also remove empty unused sheets from your workbook.
The savings here will be minimal unless you are doing something unusual.
--
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

wrote in message ...
I work in xl 2003 and from the automation create a file and save it
to the network drive ...

but I have a problem with the size of the file that getting large up to
6Megabyte
the original file is only 92 kb...