Sheet >Rename sheet, show sheet, hide sheet options are greyed out and can not be selected

Sheet >Rename sheet, show sheet, hide sheet options are greyed out and can not be selected. The calc file or sheets are not protected and not read only.

Can you edit the existing sheets in the document?
1.1. If no, the whole document is read-only. Just save it to your home directory.
1.2. The sheets may be protected against editing which can be changed via menu:Tools>“Protect Sheet”
2. In case of yes, menu:Tools>“Protect spreadsheet structure” which protects the collection of sheets.
https://help.libreoffice.org/7.5/en-US/text/scalc/guide/cell_protect.html?DbPAR=CALC#bm_id3146119

I can edit the existing sheets. The file is not protected. Under the menu tab ‘sheet’ hide sheet, insert sheet, rename sheet options are greyed out. But I can add rows and columns to existing sheets.

Then unprotect the sheet structure.

1 Like

Thank you so much. I was struggling for an hour. You solved in in seconds. Thanks once again.

1 Like