Maybe resetting the last used cell would help:

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused



MMcCullough wrote:

When I delete information from a large number of cells (or clear contents) on
a worksheet, the amount of memory allocated and the file size of the
application apparently is not re-allocated to reflect that these cells are no
longer being used. How can I "release" the cells whose contents have been
deleted or cleared? Thanks.
--
Mike McCullough

--

Dave Peterson