![]() |
Vertical Scroll Bar not responding
I have a workbook that is shared. When the user logs in she can see the data
on screen fine. However, when she tries to scroll down, the view does not change. She can Scroll Left and Right but not up and down. I tried taking off the shared feature thinking it may be a quirk with that, but it doesn't work. Is there some setting I need to change to fix this? What is going on? Someone help please....thanks! |
Tools Options View Is the vertical scroll bar box checked?
"bruner" wrote: I have a workbook that is shared. When the user logs in she can see the data on screen fine. However, when she tries to scroll down, the view does not change. She can Scroll Left and Right but not up and down. I tried taking off the shared feature thinking it may be a quirk with that, but it doesn't work. Is there some setting I need to change to fix this? What is going on? Someone help please....thanks! |
Yes it is
"bruner" wrote: I have a workbook that is shared. When the user logs in she can see the data on screen fine. However, when she tries to scroll down, the view does not change. She can Scroll Left and Right but not up and down. I tried taking off the shared feature thinking it may be a quirk with that, but it doesn't work. Is there some setting I need to change to fix this? What is going on? Someone help please....thanks! |
j.k.- figured it out. Freeze panes were accidentally clicked at the bottom
of the screen. Dooooooo! "bruner" wrote: Yes it is "bruner" wrote: I have a workbook that is shared. When the user logs in she can see the data on screen fine. However, when she tries to scroll down, the view does not change. She can Scroll Left and Right but not up and down. I tried taking off the shared feature thinking it may be a quirk with that, but it doesn't work. Is there some setting I need to change to fix this? What is going on? Someone help please....thanks! |
Do you have filters (data|filter|autofilter) applied?
Some people filter the worksheet, then apply window|freeze panes. Then they show all the data, but the frozen window portion is all they can see. Try window|unfreeze panes. If you're the culprit <vbg, apply the window|freeze panes only when you have all the data shown. bruner wrote: I have a workbook that is shared. When the user logs in she can see the data on screen fine. However, when she tries to scroll down, the view does not change. She can Scroll Left and Right but not up and down. I tried taking off the shared feature thinking it may be a quirk with that, but it doesn't work. Is there some setting I need to change to fix this? What is going on? Someone help please....thanks! -- Dave Peterson |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com