Issue with form control

New Contributor



I am using the up/down arrow "form control" in a spread sheet. I have noticed that the buttons work fine for a while but then begin to behave erratically as follows: 1) They either become completely unresponsive or 2) Both behave as "up" arrows.


As a "fix", sometimes the error seems to correct itself at random, or when I click away from the current tab, or when I save the file and then re-opened it - there seems to be no rhyme or reason to this! However, even then the issue soon re-occurs. 


I have been using this feature for a long time without encountering this problem. 


Does anyone know how to fix this problem? Is this an Excel bug?


Thank you. 

7 Replies
What if you remove it and insert a new one? In my experience, controls can start misbehaving without prior notice. I try to avoid them other than perhaps a simple button.

@Jan Karel Pieterse


I have, but that does not help.


Regarding your second comment, I have been using spinners for my educational spreadsheets for many years and have never encountered a similar issue.  


FYI, when I open the spreadsheet in an old computer which has windows 10, this issue  does not replicate and the spinners work fine, even after many tries. In fact, I had a colleague test the spinners on his computer (also on Windows 10) with the same result.


Any thoughts?

I would use Help, Feedback, I don't like something. That is always a good idea as it notifies MSFT of things that go wrong.
Hello, can you kindly advise if you got a resolution for your reported issue. I have the same behaviour with Form Controls sometimes being irresponsive, sometimes randomely working when zooming out, sometimes i can select an input but with cursor position shift. Any ideas on how you got it sorted out? Thanks in advance!
I am experiencing this exact issue on a Surface Pro with Office 365 installed. Form control up and down arrow - the down arrow behaves erratically and works correctly for a while and then goes rogue and starts behaving as an up arrow. Save and close and reopen fixes it, but i shouldnt have to do this and its putting the data collection at serious risk of errors.

Please can we get an update @microsoft if this has been resolved? I find it frustrating / hard to accept that a newer version of a product with many so called ''improvements'' can lead to reduced function/reliability.

Hi @hannahlill,


Thank you for your note.


I (and a few others) have already brought this issue to the attention of Microsoft (I also took an on-line survey today - why does Microsoft even bother with these?) but there has been no resolution.


As I write, the issue is still present (I have the latest version of Excel and I am on Windows 11).


It is infuriating that a company as large as MSFT (market capitalization of 2.9 trillion dollars, almost 1/3 of US's annual GDP) can not fix a bug in its software despite several users experiencing (and raising) the issue.


Shame on you! Get it done!