Forum Discussion
Developer Scroll Bars Suddenly Became Erratic!
DDDCi Please understand that I'm not going to click on each and every button until I know what I'm supposed to be looking for.
I'm not sure if this post was directed at me, but I am running Windows 11 on my laptop. It's resolution is 2560 x 1600. But I use a cordless mouse, not the touchpad, and I still randomly get the problem. My laptop is 15", and sometimes I have to zoom my Excel workbook to 140% to get the buttons to start working again, and even then there is a very small corner that will activate them.
I suspect the problem shows up ONLY on a high-resolution laptop running Windows 11 when you use the touchpad (not the mouse).
1. Can you post your laptop resolution?
2. Were you able to solve the problem?
Ramon.
- 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.
- Soooooo I have been dealing with the same issue,
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. Unfortunately I have been unable to, due to travel. For now, I am remote-logging into my desktop as needed.
- Hello Shiv,
Did you tried that? What happened? I'm not sure if it solved my problem, but Microsoft tech support took one of my worksheets that was not functioning properly and copied everything into another work book. I never was able to get it to freeze up after that. But, when he did this he did move the workbook off of my second monitor to my laptop monitor. Still, this doesn't explain the issue, just a possible fix until the next update that mysteriously fixes a problem that no one seems to acknowledge except a select few.
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!
- Did you find any solution to this problem? I have similar issues. I have scroll bar form control buttons that have a range of 1-100 that I use to calculate a percentage of increase. In the last week they have started doing strange things. Sometimes they just freeze, some times they decrease when they should increase, sometimes one will stop working and the others will work one or twice more before they freeze as well.
I am having the same issue. I use scroll bars on a user interface and they work perfectly on my desktop computer but not on my mobile workstation. The left and right arrows on the bar are visible on the desktop (same file) but not on the laptop. The bars keep freezing or acting erratically on the laptop but not on the desktop. I am running Windows 10 Pro on the desktop and 11 Pro on the laptop. Both are running Office 365. My plan is to uninstall and re-install Office 365 on the laptop to see if that fixes the problem. Not sure what to do if that doesn't work.
- Have you been able to solve the issue?
I am facing the same problems that you are describing with the Scroll Bars in one of my workbooks.
It's quite annoying since I cannot even find any pattern on when they stop and start working again.
Any idea on how to solve this is highly appreciated! - Quite strange!
Anyway, thanks Riny! DDDCi Looked at all of them, pressed all of the spinners and pulled on all the slides and they do exactly what they are "told" to do in their Format Control settings.
Nothing erratic. Sorry!
- Yes, of course. Sorry, I am new at this!
What should appear also at your end is sliding bar and spin button erratic behavior. Normally, you would expect numbers assigned to each sliding bar and spin button that are positioned to the left (all three sets) to change on command. On the attached Excel file, this does not occur, hence "erratic behavior."
So, if you were to test whether the numbers change as demanded (i.e., move slider to left or right and the numbers change as arranged, or click the lower spin button and the numbers should go to the extremes) on all the sliders and spin buttons, then I expect that you would see that not only do not all of them work, but they do not work all the time neither! So, sometimes the first few sliders will work, and the bottom ones would not. Then, the bottom ones would not work, the upper ones will! Or, no matter if you click the lower spin button, the upper one will be activated, and so on!
Temporarily "fixing" this is is done by zooming in or out, of all other "solutions!" What on earth does zooming has to do with this problem?
Alternatively, perhaps you can slide all the sliders and all spin buttons (upper and lower) work at your end reliably? In such a case, the problem would then be local, which is even more challenging!
