Nov 15 2018 10:30 AM
Nov 15 2018 01:37 PM
For Excel 2016 that is File->Options->Advanced. Approximately the same for other versions.
Please clarify, you can't edit within the cell or in formula bar?
Dec 19 2021 11:05 AM
I have same problem. I was using an add in to access Data. Now my excel is constantly not allowing me to do anything on it. I cannot move from one cell to another or typing anything.
And more, I am only able to do use a file if I starting excel on safe mode.
It is becoming almost impossible to run my excel 365.
Thanks for helping
Nov 10 2022 08:00 AMSolution
@Amanda Voyles I know this is an old question but I had a similar problem (might be different for yourself) which took me longer than it should to realise but directly to the left of the formula/text box up top there is a tick and X button. Hit the X.