I maintain a shared Excel workbook on a server which is updated by various
people. Somehow the last cell on various worksheets gets set to a location
far below the last row used. Example on one sheet: the last row used is row
738, the last cell reference is Z:7948. I've tried deleting the unused rows
and tried selecting the rows and "Edit/Clear/All". Neither works. The only
solution I've found is to insert a new worksheet, copy just the filled cells
and paste to the new worksheet which involves quite a bit of formatting. The
big problem is that when the workbook is saved it takes about 3 or 4 minutes
and wastes server space because it so large. Anyone have an easier solution
to changing the last cell reference? Thanks!

Have a look at: http://support.microsoft.com/kb/244435
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bob" <(E-Mail Removed)> wrote in message
news:94C7656C-93F2-4A19-B404-(E-Mail Removed)...
>I maintain a shared Excel workbook on a server which is updated by various
> people. Somehow the last cell on various worksheets gets set to a
> location
> far below the last row used. Example on one sheet: the last row used is
> row
> 738, the last cell reference is Z:7948. I've tried deleting the unused
> rows
> and tried selecting the rows and "Edit/Clear/All". Neither works. The
> only
> solution I've found is to insert a new worksheet, copy just the filled
> cells
> and paste to the new worksheet which involves quite a bit of formatting.
> The
> big problem is that when the workbook is saved it takes about 3 or 4
> minutes
> and wastes server space because it so large. Anyone have an easier
> solution
> to changing the last cell reference? Thanks!