Forum Discussion
Zico1715
Aug 17, 2022Copper Contributor
Issue with form control
Hi,
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.
- hannahlillCopper ContributorHello
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 Pernille-Eskebo 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.- Zico1715Copper Contributor
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!
- JKPieterseSilver ContributorWhat 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.
- Zico1715Copper Contributor
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?
- JKPieterseSilver ContributorI would use Help, Feedback, I don't like something. That is always a good idea as it notifies MSFT of things that go wrong.