The data is not stored in memory, just the markers for those cells.

Excel just forgets to reset the used range after you delete the data.

Delete the rows and columns outside the actual range of data then save the
workbook. You may even have to save. close and reopen.

Excel will reset the used range.


Gord Dibben MS Excel MVP

On Thu, 20 Dec 2007 13:26:01 -0800, z.entropic
wrote:

Here is the observed behavior: when rows or columns of data in the worksheet
are deleted, and when one tries to find the data-occupied worksheet area by
pressing Shift-Ctrl-End for, for example, fast charting, Excel 2003 gives the
old dimensions, not the actual ones.

Where is this old data located in memory, and how to access it?
z.entropic