UPDATE: CAN'T Fix? : Formula Bar Now at Bottom of Excel (for Android) Screen

Anonymous
2022-01-15T19:25:31+00:00

Happy 2022!

A couple days ago, I opened a spreadsheet (that I update, daily), & discovered that the Formula Bar had moved to the bottom of my screen. It still does what it's supposed to, but this positioning makes life difficult in multiple ways (details below).

I can't find an update to the Excel app, or Android OS, that seems recent enough to be responsible, though the Excel screen did seem to become set, approx the same time, to match phone's day/night color schemes.

I can't find any mention, or images – online, on Microsoft.com, in tech pubs/blogs, or community forums – of this behavior, or of any way to move the Formula Bar.

Can anyone provide insight into what happened, or how to fix it?

NOTE : System + app versions follow screenshot, along with "difficulties caused" – mentioned above.

Many thanks for any solution(s?) &/or insights❗

___________________

UPDATE: This morning [22-May'22], I opened Excel, on my Android phone, & MS "asked" whether I've enjoyed the "Updated Feature: …Has your editing experience become easier having the Formula Bar at the bottom?" {see add'l att}

BINGO ❗ IT'S A FEATURE, NOT A BUG

[Does not explain why an MS rep would request info, trying to replicate the "Feature"]

————————

————————

PHONE : Samsung Galaxy S21 (5G)

OS : Android version 12

  : One UI version 4.0

  : Android security patch 1-December'21

EXCEL (for Android) : V 1.0.1 (16.0.14729.20146)

PROBLEMS

• Decades of Excel habits, using Formula Bar at top.

• Pop-ups, while typing (suggestions, option selection, etc.), display on top of toolbar, making click/select errors – that clear all content from formula/data entry field – inevitable.

• Enlarging the Formula Bar covers bottom (typically more important) rows of spreadsheet, + makes them trickier to access.

Microsoft 365 and Office | Excel | For business | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

114 answers

Sort by: Oldest
  1. Anonymous
    2022-01-16T07:24:43+00:00

    Hi Kiel.A:

    Thanks for your feedback and screenshots .

    No similar problems occurred in our tests.

    Please try resetting your Excel application to see if this can be fixed. Go to Setting->Reset.

    If the problem persists, I would like to know if creating a new workbook will still cause the problem.

    Best regards,

    Tin

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2022-01-18T00:53:53+00:00

    Tin,

    Thank you – for the quick response, & suggestion.

    Unfortunately, it did not change anything. Backing up, I have a professional tech background, & should have mentioned other steps I'd already tried, when I posted. Your suggestion would still have been new, & worth trying, but, now, for the record, here are some of the other steps I've tried – some before, + some after, reading & trying your suggestion. None provided any change/improvement; I :

    • Cleared the Excel cache, in Android Settings, + Powered off & Started the phone (did not 'Restart'), before rechecking
    • Created a new blank workbook, first with my phone, then with my Win10 desktop (which has never exhibited this problem); reopening either on my phone made no difference; but either displayed fine on my desktop
    • Uninstalled Excel, then Powered off + Started the phone, before reinstalling & checking Excel
    • Since Excel's in-app Settings, on my phone, only offer "Reset Office", I first just reset Excel (Force-stopped the app, then cleared its cache + data), then Powered off + Started the phone, before opening Excel
    • Your suggestion: Used Excel's in-app Settings, to "Reset OFFICE" (I was surprised at how quickly this occurred – the app seemed ready to allow me to open a workbook, more quickly than if I'd just closed a workbook), but still no improvement, before or after restarting

    I'm still stuck, and at a loss.

    One STRANGE BEHAVIOR/observation that may be worth noting – I have a pair of Samsung Galaxy Tab S4s – that's the model that came out approximately when Office pricing changed, & has a screen that's 0.1 inch too large to qualify for a free copy of Office for Android (which is not a problem, as I don't use either for anything requiring Office functionality).

    FTR: I own/use full, legal software + licensing for local-install Office Pro and Windows 10 Pro.

    This afternoon, I became curious, & checked one of the Tabs. Initially, behind text advising that I could not save any changes without subscribing to Office 365, I could see that the function bar was at the bottom of the screen, same as on my phone. After resetting office on my phone and restarting both tablets, I checked them, & both, thru the same warning text, now show function bars at the top of the workbook page, like my desktop, + like my phone, just last week. Go figya‽

    Any further advice, suggestions, recommendations, etc., would be greatly appreciated, EXCEPT a full Factory Data Reset on my phone. That will, no doubt, at some point, become inevitable, & I will check this, then, but given the time already spent on this issue I can't afford more days, configuring my phone to be just what it otherwise is, today.

    Thank you,

    Was this answer helpful?

    9 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2022-01-18T03:07:13+00:00

    I've got the same problem on a Honor 20pro, Android 10, Magic UI 4.0.

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2022-01-19T02:38:15+00:00

    Same problem as well. S21+

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2022-01-19T03:47:50+00:00

    Since there are now 3 people reporting the same new & (dis)"improved" "feature" I suspect it is MS playing silly bug**s with Excel Android.

    .

    They are doing similar stuff in Office on Windows 11, but not as drastic.

    .

    I strongly suggest you (all 3) send a feedback to MS complaining about this (dis)"improvement".

    .

    Feedback Hub

    The “Answers” forum / community is “staffed” mostly by users like yourself, unpaid volunteers. This forum is intended more for “How to do something in application A” type questions. We sometimes can provide work-arounds for problems, but we can’t do anything about underlying problem. If the forum can’t solve your question you need to talk directly to MS, you need to submit a “Feedback” to MS.
    .

    For a couple of years now MS has had a "feedback" process that allows users submit bug reports / problems, suggestions and new feature requests directly to MS developers and managers. You can submit feedbacks from within many MS apps, or you can use the Win10 “Feedback Hub” app. This article describes the different ways you can submit Feedback to MS:
    https://answers.microsoft.com/en-us/msoffice/forum/all/microsoft-feedback-process/6f850368-8c86-481d-a207-d95b265c4be4
    .

    There is also a new web based “Feedback Portal” in development. It is still labelled “Preview”. It provides functionality similar to the feedback hub. Access to feedbacks submitted in 34 categories.
    https://feedbackportal.microsoft.com/feedback/

    .

    As users we are unpaid quality control testers, we identify bugs, they pick which feedbacks they will work on, and when they will release them, for testing by Insiders and to general public.
    .

    But don't "expect" anything like feedback about your feedback back from MS.
    .

    MS will make fixes and changes on their own schedule.
    .

    They will not provide much, if any, advance notice of what they are working on and/or when it will be released.
    .

    Hint : get a “share” link to your feedback (may take a couple of minutes to process the initial submission of the feedback) and post the link back to this question. That way if someone finds this question they will be able to link directly to your feedback so they can vote for it and add their comments. The more feedback on a subject, the more likely it is to be acted on.

    i.e.

    "Feedback" suggesting that they create a "Support / Support" category in the feedback app to collect complaints about poor service in MS Support: https://aka.ms/AAdyeq0
    .

    PS: also be publicly vocal about your complaints.  Post on social media

    .

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments No comments