Try resetting the last used cell.
Debra Dalgleish shows techniques:
http://contextures.com/xlfaqApp.html#Unused

pj wrote:

How do you get the slider bar on the right side to go to the end of where the
data is instead of way past where the data ends.
There is no other data beyond where my actual data ends and I have deleted
the extra lines but the slider still wont move up.

Thanks - PJ

--

Dave Peterson