Calc: cannot add/delete sheets to spreadsheet

I have a spreadsheet with 11 sheets. I cannot add or delete any sheets.

The plus sign is there; I can edit and save sheets. The Menu:Edit>Sheet>Delete option is disabled. As is Move/Copy.

Is there an option I should have left alone?

Are there ways to find out if the spreadsheet is corrupted?

Versions: W7 (English), LibreOffice latest, Calc

What does context menue (click right) of the sheetTAB tell you for a sheet that cannot be deleted? Does the item ‘Protect Sheet…’ have a “checked” mark?

1 Like

Solved! You put me on a right track. There also is Tools > ProtectDocument > Document… I had inadvertently added a password disallowing sheets to be added or deleted. I must have done that some time ago because I totally forgot.

Solved! There also is Tools > ProtectDocument > Document… I had inadvertently added a password disallowing sheets to be added or deleted. I must have done that some time ago because I totally forgot about it.

I do want to add that’s it a little confusing to still have the ‘+’ tab at the end of the list of sheets, suggesting additions can be made.

1 Like