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

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>

Hi, I'm. experiencing the same, and I  wonder if this will deal with the fact.that my file runs on the company shared drive as well?

i was presenting and when I need to make changes, the cell can't be edited. 

thanks 

regards

I had exactly the same problem today. Tried typing in the "A" column round about row 150, and however hard I tried, the cell would just not populate. Columns to the right, B....... etc, were absolutely fine. All rows in Column A beneath row 150, would similarly not populate.

After much messing around with no success, decided to make a style change by using the cell styles button in the ribbon. Lo and behold, success. Have absolutely no idea why that works, but it has worked for me.

I did think that maybe the font colour had something to do with it (i.e typing in invisible ink if you know what I mean), but I did try changing font colours with no effect whatsoever.

Others might find it works for them also

I have exactly the same issue. Appreciate other people’s patience to follow long threads with MS. 

I’m very proficient with Excel, used it for 30 years and never has this problem until recently!

This doesn't work for me because my employer regulates what I can download.  We use Box for all our files.

I am also having the same issue running Excel in Office 365 with the latest updates and it occurs quite often. Looking back at this thread and other ones like it this seems like a pervasive problem that has existed for years and Microsoft seems to not be able to address it or cares not to.

Which one is it - don't care or don't have a clue - they both make Microsoft look bad....

Nicoli