This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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>
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
I have the same annoying issue in my current PC (I7-8565U / 8GB Ram) and in a previous PC (I7 6th generation / 8GB Ram). Both running MS Office 365 home in win10.
When is MS going to solve this pretty old and known issue?
Personally I never had any issue with OpenOffice...
It might happen BUT usually open source community is very responsive to solve bugs and problems so I think all the cases they faced in the past should cover 90% of common bugs. They wouldn't leave such issue for... 4-5 years like Microsoft is doing.
There is a workaround for this bug:
Open the file with OpenOffice.
Enter anything in an empty cell and save.
Re-open with Excel and it works.
Did that already for 10-15 files, worked all the time for us !
Are you not afraid that when you open the excel file with OpenOffice, there might be some formatting or data loss especially if the file is complex or you have lots of formulas?
There is a workaround for this bug:
Open the file with OpenOffice.
Enter anything in an empty cell and save.
Re-open with Excel and it works.
Did that already for 10-15 files, worked all the time for us !
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>