Scroll bar moves too short

  • Thread starter Thread starter Dima
  • Start date Start date
D

Dima

Hello!
A sheet scrolls to a data end with a vertical scroll bar in 1/50 of a lenth
of a scroll bar area from the upper end.
How to make the sheet scroll to the data end with the scroll bar movement to
the scroll bar area end?
Regards,
Dima
 
Thanks Bob for replying!
I deleted all rows after 473. This does not resolve the problem in my file.
Regards,
Dmitry
 
Sounds like you deleted contents not the rows. Delete the rows with
R-click menu Delete.(not pressing Delete key)
 
Thanks Bob for replying!
I did not delete contents. I deleted the rows with R-click menu Delete. (not
pressing Delete key)
Regards,
Dmitry
 
Thanks Bob for the suggestion!
I did not find a macro that accesses a cell on row 50147 and I deleted all
marcos in the Macro window. But I still get a a window asking if I want to
allow running of macros at the xls file opening.
Regards,
Dima
 
There is certainly more to this than meets the eye. Perhaps you want to
copy just that worksheet to a new workbook instead.
 
The prompt window to allow a macro does not appear when I open the other file
with the copy of the sheet.
 
Ok, then all is correct with the location Excel is identifying as Last
Cell. Perhaps there is something set in Print area that is doing this?
 
I still have not resolved the problem.

Bob I said:
Ok, then all is correct with the location Excel is identifying as Last
Cell. Perhaps there is something set in Print area that is doing this?
Click to expand...
 
We have exhausted the items that I know of, perhaps you may run Office
Diagnostics on the Office installation.
 
Back
Top