Oct 07 2022 01:11 PM
Oct 07 2022 01:11 PM
I have a sheet that I use for tracking statistics. Each cell contains a simple number with 0 decimal places.
I have added a spin controls in my sheet to simply increment and decrement the value of a field by 1.
As I have added and tested the spin controls, I have found that many of them will only increment the field, not decrement the value. Both the up and down buttons are visible, but when clicking the down arrow in the control, the field is incremented improperly.
Thanks for the help
Dec 15 2022 10:38 PM
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.
Dec 23 2022 04:29 PM
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!
Jan 02 2023 12:42 PM
Jan 04 2023 03:43 PM
Jan 25 2023 05:10 AM
Feb 14 2023 10:43 AM
Apr 19 2023 10:32 AM
Jul 17 2023 07:19 AM
Same problem here. Seems amazing MS have let this basic fault in their software go unfixed for so long. To attempt a workaround I replaced all the form control spinners on the worksheet with active x spin buttons. Bad idea! The active x controls broke after being hidden and, after a while, it seemed they would spontaneously self-destruct when moving the worksheet in any direction that was not aligned with some mystical meridian. So, its back to the equally buggy form controls and hoping for a solution. The disadvantages of the, effective, MS monopoly really bites home when these things happen.
Aug 02 2023 06:18 PM
Oct 02 2023 05:10 PM - edited Oct 02 2023 05:12 PM
Same issue. It's been nearly a year since the first post and the issue STILL exists?!?
In my case, the spinners on rows 3 and 10 work fine. All spinners below that show the issue.
I mean ... come on, Microsoft. Maybe it's time to fix this?
Oct 03 2023 09:09 AM
Oct 16 2023 06:20 AM