Unable to enter anything into a cell
While working on a Excel for Mac, I suddenly cannot enter any data in ANY cell. Also the same thing with all my spreadsheets, unrelated to the one I was working on. I can type numbers and letters on email and blank pages, but not on the spreadsheet. Help
65 Answers
It's not that you needed to close another workbook; all you need to do is to click on a different workbook, and then you can then come back and edit the cell in your original document. Just taking the focus away from the first document frees it up.
We can reproduce this at will, but we don't know why or what makes it happen to get stuck in the first place. Others on the web have this issue as well. So far, only 1 of our users have this issue and we just put everyone onto 2013.
The issue could be because of the following option might enabled in your excel. Please un-check "Transition formula evaluation" and "Transition formula entry" options under "File > Options > Advanced. These two options available at the bottom of 'Advanced' option.
Hope this helps
This happened to me - super frustrating. It turned out I needed to close a second workbook that I had open. I don't know why, but it worked.
It seems that there are several things that could be causing this issue.
NC Admin's solution worked for me, but I was able to fix it myself by making my formula bar viewable. (View > Formula Bar). After unhiding the Formula Bar and editing a cell's text, I was able to hide it again and still be able to edit a cell's text.
I have had this problem. I would be unable to enter data in a cell and would have to switch to another worksheet and back. This could happen every second cell update. I had another (timesheet) spreadsheet open, with hundreds of worksheets. When I closed that spreadsheet, the problem went away.
1
