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
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.
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.