I use Microsoft Office 365 ProPlus running over Windows7 64 Enterprise. While I work on an Excel spreadsheet, it will often refuse to let me edit a cell. I click in the formula bar but the editing cursor doesn't appear. When this problem occurs, I am then unable to edit any cells in the spreadsheet, or use the arrow keys to move to different cells. I can still use the mouse to select (but still not edit) other cells. I can restore my ability to edit cells (at least temporarily) by selecting/clicking on another (second) sheet/tab in my spreadsheet and then returning to the main sheet. Is there any way to stop this intermittent "no editing allowed" behavior by Excel?
Update: I have determined that this problem only occurs after having multiple Excel spreadsheet files open for several hours. If I close all current instances of Excel on my PC and then reopen Excel from scratch with the problem spreadsheet, this problem doesn't occur. I have decided that the problem is caused by some subtle memory leak or other bug that is "fixed" by opening a fresh copy of the the Excel program.
Best Answer
Quick fix - select one of the other open spreadsheets and click on a cell in it. Then return to the spreadsheet you were working on and carry on... ...until the same thing happens randomly later!