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!