Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Losing scroll functionality - weird
Hello,
I am running a workbook that is shared by a few users. Occasionally, we lose the side (up & down) scrolling function and we have to close the workbook and reopen it and then everything is fine. I think this may be link to using filters, but I can not narrow down the exact cause. Has anyone had this happen to them? What is the cause? How do I fix it? Any help or ideas would be great. Thanks, |
#2
|
|||
|
|||
Hello, I am running a workbook that is shared by a few users. Occasionally, we lose the side (up & down) scrolling function and we have to close the workbook and reopen it and then everything is fine. I think this may be link to using filters, but I can not narrow down the exact cause. Has anyone had this happen to them? What is the cause? How do I fix it? Any help or ideas would be great. Thanks, Also - when I use the up & down scroll arrowns, I can see the scroll bar moving, but worksheet does not scroll....maybe it has to do with frozen panes? I do have the first two rows frozen....help. |
#3
|
|||
|
|||
Sometimes when people use Data|filter|Autofilter and Window|Freeze Panes, they
filter the data to show what they want and then apply the freeze panes. If the first row (discounting headers) is (say) row 333, then when you unfilter, the freeze panes could still be under row 333--so you can't see your scrolling. Try turning off the freeze panes, then show all the data, then apply the freeze panes. Mike R. wrote: Hello, I am running a workbook that is shared by a few users. Occasionally, we lose the side (up & down) scrolling function and we have to close the workbook and reopen it and then everything is fine. I think this may be link to using filters, but I can not narrow down the exact cause. Has anyone had this happen to them? What is the cause? How do I fix it? Any help or ideas would be great. Thanks, Also - when I use the up & down scroll arrowns, I can see the scroll bar moving, but worksheet does not scroll....maybe it has to do with frozen panes? I do have the first two rows frozen....help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll Lock | Excel Discussion (Misc queries) | |||
How do I restrict any one not to scroll more than 100 row? | Excel Worksheet Functions | |||
Excel, horizontal scroll bar and sheets not accessable anymore | Excel Discussion (Misc queries) | |||
scroll bar | Excel Discussion (Misc queries) | |||
how to fit my column unmoved eventhough i scroll down? | New Users to Excel |