Forum Discussion
Developer Scroll Bars Suddenly Became Erratic!
Greetings!
So far, I have found that space (of all things) has something to do with it! The location of the scroll bar in your screen space impacts whether it will work properly or not. For example, some of my scroll bars above would work well if they are placed (via the usual side slider) to the upper area of the screen (once zoomed out enough), while others in the lower area.
One reason why the attached Excel file does not work in my computer but it worked at Riny's (when he says that he tested it), may be because I use a TV for a screen while he may be using a computer screen? Can you confirm this, Riny? If that is the case, then it should be an output problem.
However, this does not explain why they worked properly before, while suddenly became erratic! I am using this same TV screen for years! So, if that is the case, then perhaps an update may have indirectly mingled with our previous output settings and lead to this erratic behavior!
This is all I got at the moment! Hopefully, the same problem happens to even more Office tech advanced people, so as they could share their solutions with us! The problem still persists!
I think i found a solution... Well, it worked for the spin controls.
Ctrl + Mouse wheel scroll up 1, then scroll down one.
(This zoom in/out seems to reset the button clickable area)
All of my down buttons now work.
- I am running into that same issue when moving it from the laptop to monitor. Closing and opening does fix the issue. Also it seems being at 85% zoom I have had less issues with the buttons but it still happens.
The Zoom in/out does fix it when moving the sheet around. But I plan to just leave it on the side of my screen since I use it for counting emails and time tracking.
Still wish it could just be fixed overall. What I have discovered is that the issue seems to be related to my secondmonitor. The display resolution is different between my laptop monitor and my second monitor. So, if I drag an excel document from the laptop screen to the second monitor where the resolution is lower it seems to cause the issue. Some documents that I issues with now, I can move to the laptop, save it, close it and re-open it, the issue goes away. Try this and let me know if it works for you.
