Excel 2016 - Cannot type anything into a cell all of a sudden

Anonymous
2017-04-14T07:08:05+00:00

Hi,

I am experiencing a problem with Excel 2016 that is really frustrating.

I am working normally in excel 2016, when all of a sudden I cannot type anything into a cell. If I press Ecs nothing happens. I do not have macros, nor protected sheet or cells. I am working with multiple (2 or more) open excel files at the same time. I tried to figure out, if I press some combination of keys that would cause this, but found nothing. I, however, can move the mouse over the sheet and click different cells. I think the arrow keys work as well.

The strange thing that always "solves" the problem is pressing Enter. Pressing the Enter opens another Excel file that is already opened, and after simply going back to the first one, I then can work on normally. This can occur once, twice but sometimes even 10-times in a single day! Just terrible.

This is time demanding, many times I write into a cell and then see that the cell is still blank, I press the enter to make it work again, going back... - I cannot work like this.

When I was working with the same files in Excel 2013 and 2010 I hadn't have experienced such problems. 

I already read some other forums with people experiencing the same problem, but haven't found any solution yet.

Do you have any?

Thank you!

P.

<Thread has been moved to the correct category by forum moderator>

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 No comments

169 answers

Sort by: Most helpful
  1. Anonymous
    2019-07-13T23:15:36+00:00

    I am having this type of problem also.  I have an hp, but emailed the workbook to myself so that I could work on my imac to see if I could fix the problem.  The imac has office 2013 for macs, and it works fine.  I emailed it back to my hp, but once it got back, the same problem occurred.  it must be a flaw in the program.  hope they come out with a fix because this is frustrating!

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-06-21T17:05:50+00:00

    Same problem here. I run multiple workbooks simultaneously. Microsoft, have you a fix for this? It's affecting my productivity.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-06-17T19:18:36+00:00

    I have this exact same problem. It has happened on several different computers and many different files.

    It is very frustrating.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2019-04-10T20:15:21+00:00

    I installed OpenOffice but when I try to open my first file it fails to open.  A Green bar at the bottom has the word "Loading..." but it never finishes loading.  Total bummer.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2019-04-05T12:41:48+00:00

    Solution is pretty easy:

    Download OpenOffice (https://www.openoffice.org)

    Open your Excel with OpenOffice

    Save it as Excel

    Open it with Excel: problem solved.

    Had this issue many times with my users and it solved the issue EVERYTIME for us !

    Thanks to OpenSource community !

    Was this answer helpful?

    0 comments No comments