Forum Discussion
Spin Control only increments
I was having the same exact issue, I had 10 spinners on worksheet at first they work as intended and then after a few hours they started doing what you described, only incrementing no matter if I click the up or the down arrow.
Rather randomly by the way I happen to notice that you can get them to decrease the value if you click the very very bottom of the spinner, below the down arrow itself on the bottom border. I'm sure there is a reason for this but I can't say I know what it is.
I couldn't get them to function properly no matter what until I went into add/remove programs and found office, clicked advanced options, and proceeded to do first the repair and then reset option afterwards when repair didn't work.
They seemed to work as intended after this, well for a few hours and then right back to this frustrating behavior you described. I had a windows 11 update pending which I restarted for and now after that, they work normally again for the last day and half.
I'm not sure if any of this is helpful but I didn't really see any answers for this issue so hopefully it might.
- Rayburn
Discovered that toggling Page Break Preview on and then back to Normal view rectifies the issue at least temporarily
I am encountering the same exact issue (M365 Excel + Windows 11).
I found that when you resize the spin control significantly (like 3x larger), the 'click zone' of the down arrow is enlarged enough for you to hit it successfully and it will de-increment as expected.
Of course the problem is that I don't want to resize the 12 spin controls I have on this sheet and the hundreds I have in other workbooks.. And I definitely don't want them all to be 3 times larger just to get them to work!
- I'm encountering the same issue. I confirmed that when you resize the control larger it will allow you to click the down button, but then restoring the size to original goes back to only increasing. This wont be a good workaround for the end user, but it does help troubleshoot and confirm the problem.
