There are instructions here for manually or programmatically resetting
the used range:

http://www.contextures.com/xlfaqApp.html#Unused


verc wrote:
Recently I've started to be given spreadsheets of data to analyze, and
the spreadsheet extends to 65000 rows even though there are more like
2-3000, such that when I try to press ctrl-end to go to the last row,
it takes me to 65000 instead of where I actually want to go. Can anyone
suggest a fix for this?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html