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/lastcell.htm#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.
