Share via

Excel for Android - blank formula bar after switching between apps then back to Excel

Anonymous
2019-09-07T11:28:27+00:00

I have Excel open with a timesheet Spreadsheet most of the day on my Samsung Note 8 phone, but switch to different apps as required throughout the day. 

When I switch back to Excel to update the timesheet file, the Formula bar does not usually display the data that is currently in the cell (most of the time). If I tap somewhere in the Formula Bar and start typing, I cannot see what I am typing in the Formula Bar, but can see what I am typing in the Cell.

If I close the app and restart and load the file again, it usually works okay.

This problem has been present for a long time (Years) and has never been fixed. The problem was also present on my last phone (Asus) and possibly earlier.

The Spreadsheet is not protected.

Any solutions?

Thanks.

Microsoft 365 and Office | Excel | For home | Windows

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

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-09-07T13:22:06+00:00

    Thanks for your reply. 

    I'm assuming you are meaning Excel for Windows. In Options/Advanced Options, there is the option to display or not display the Formula Bar.

    The problem I'm having is with Excel for Android. There appears to be no option to turn the formula bar on or off in Settings. It is always there. It is the data that is in the cell is not showing in the (visible) Formula Bar.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2019-09-07T12:36:10+00:00

    The software is pre-installed on the Note 8, so all I can do is uninstall all the updates.

    I have done this and reapplied the updates and it still does it.

    To replicate the problem, open Excel for Android, enter something in a spreadsheet. Don't save the spreadsheet.

    Switch over to other apps for a while, then switch back to your spreadsheet and tap on the cell you entered (which is visible in the cell). However the Formula Bar is blank. 

    If you close and save the spreadsheet before you switch to another App and then re-open it when you switch back to Excel, it works okay.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2019-09-07T12:13:36+00:00

    Hello,

    I am an independent advisor, and I am trying to help other users in Community with my experience in Microsoft products.

    Try to uninstall and reinstall the application of Office.

    https://support.office.com/en-us/article/set-up...

    I hope this helps.

    Do let me know if you require any further help on this. Will be glad to help you.

    Thank you

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2019-09-07T16:23:58+00:00

    Hi,

    I suggest you contact the Microsoft Chat support.

    https://support.microsoft.com/en-in/contactus/

    Also, I think there is a problem with your Android tablet. I recommend that you can contact the Android solution.

    Thank you

    Have a great day.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-09-07T12:39:38+00:00

    Hi,

    Thanks for writing back.

    The Advanced options of the Excel Options dialog box. Click on the Show Formula Bar check box. If it is selected, then the Formula Bar is displayed; not selected means it won't be displayed.

    Thank you

    Was this answer helpful?

    0 comments