Debra Dalgleish shares some tips on how to reset this last used cell:
http://contextures.com/xlfaqApp.html#Unused

If you can't get this to work, could you copy the stuff you want and paste to a
new worksheet. Then delete the old worksheet?

Be careful if you have links between sheets.

CJN wrote:

Somehow a worksheet I have thinks that I have somethink in the last row
which is 65536. I checked that row and I don't. Meanwhile the worksheet is
sluggish due to its size.

I tried deleting the bottom 65000 rows but it hangs my computer.

Is there another solution to this problem?

--

Dave Peterson