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

Anonymous

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!

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

169 answers

Anonymous

2018-06-19T08:57:05+00:00

If they are in denial, they are in denial for several years now. And nothing has changed so far.

I will send this link with complains directly to our country's Microsoft represential and demand answers. I will call them as well. Maybe you all should do the same.

I can no longer work like this.

Something has to change, writing here about our problems without any response/solution/anything whatsoever from Microsoft is disrespectful to their customers!
Was this answer helpful?

0 comments No comments
Anonymous

2018-06-04T15:41:09+00:00

I recently purchased a new computer for work that has Excel 2016 and I am experiencing this same problem. It does not happen all the time, but I will be working on a newly created worksheet and it will randomly stop working. I can click on cells, but I cannot enter any data into them, nor can I save the file. If I click the Enter button, it will bring up another excel worksheet that I have open, and then I can click back on the one that I was working on, and it will work again for a while. It happens on multiple different worksheets, that are all newly created so are not something that I am bringing over from an older version of excel.

Is there any update on what will fix this issue?

Becky
Was this answer helpful?

0 comments No comments
Anonymous

2018-05-11T02:03:44+00:00

Yup, our company is using the full 64 bit 2016 install. So the Office365 click to run version doesn't have this issue?? Now that's interesting....
Was this answer helpful?

0 comments No comments
Anonymous

2018-05-09T16:23:39+00:00

Is this only affecting Office365 click to run installations, or are people having this issue on 2013/2016 full installations of Excel?

I've seen this happen on the full installation of 2016 64 bit.
Was this answer helpful?

0 comments No comments
Anonymous

2018-04-11T00:46:24+00:00

For my company's case, I can't give the full specifications for all the workstations involved but I really doubt that they are using any really resource intensive applications, especially since they can't install anything. Basically just a few excel worksheets, Outlook and a few minor applications. Should have plenty of resources left over.
Was this answer helpful?

0 comments No comments