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