Changing sheet name

Tried changing a sheet name both using menu/sheet and the double click method. Neither seems to work. Couldn’t find any other help online without using a macro.
— LO7.2
— Originally imported from Excel about 3 years ago
— File is password protected but I’m able to store/restore without any problems.
— First time I’m trying to change sheet name.
Suggestions? Thanks.

Right-click on the sheet tab and choose Table rename.

File is password protected…

This could be a problem.

Right click on sheet tab gives: Select All Sheets / Protect Sheets / View Grid Lines / Sheet Events; no Table rename.

Unprotecting spreadsheet doesn’t seem to help either.

Probably the spreadsheet structure is protected. Menu Tools → Protect Spreadsheet Structure…

2 Likes

Bingo! Thanks!