Forum Discussion
Spreadsheet can not be insert or delete or clear content
I have a daily updated spreadsheet recent found can not do insert row or column, can not delete cell and clear content, and can not do auto calculate, all these without pop up a prompt, just no reaction, but if copy and paste the formula then press enter the calculation still work, these are really bothers me. I am sure this spreadsheet is not locked or with maximum rows or columns
- check sheet protection, inspect workbook protection, check for shared workbooks, look for conditional formatting or data validation, verify calculation options, test in Safe Mode, disable add-ins, clear Excel cache, try another workbook, repair Office installation, and check for updates.
