Ask Your Question
0

Why can I not delete or create new sheets?

asked 2019-11-10 18:02:58 +0100

Stewartry gravatar image

I have a spreadsheet with 17 sheets. I want to delete some and create some new ones but the 'Delete Sheet' instruction is grey. I am not tracking anything. What am I doing wrong? Right clicking on the sheet tab does not help either as a number of the usual options just aren't there.

edit retag flag offensive close merge delete

Comments

Your description sounds like document(s) is/are opened write-protected.

Opaque gravatar imageOpaque ( 2019-11-10 18:09:54 +0100 )edit

Or with structure protected.

Mike Kaganski gravatar imageMike Kaganski ( 2019-11-10 22:11:56 +0100 )edit

No. These were, of course, the first things I checked. The spreadsheet, as you can imagine, is complex and has some graphs on one of the sheets. Could it be anything to do with that?

Stewartry gravatar imageStewartry ( 2019-11-11 10:05:23 +0100 )edit

Graphs/charts don't make the document structure read-only.

Are you sure that the document structure isn't protected? Because that exactly results in some menu items being greyed out in the Sheet menu and the context menu on sheet tabs showing less items. See Tools -> Protect Spreadsheet Structure...

erAck gravatar imageerAck ( 2019-11-11 13:52:37 +0100 )edit

That was the answer. Thank you. I was not aware of the option to protect the structure and I have no idea how it got set. I have now unset it!!

Stewartry gravatar imageStewartry ( 2019-11-12 14:46:16 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-11-11 10:12:09 +0100

Stewartry gravatar image

I guess I should have answered rather than commented so here is my answer (same as comment!).

No. These were, of course, the first things I checked. The spreadsheet, as you can imagine, is complex and has some graphs on one of the sheets. Could it be anything to do with that?

edit flag offensive delete link more

Comments

Please don't use the Answer field if it's not an answer or solution to the original problem. Use add a comment or edit your question instead to provide further details. Thanks.

erAck gravatar imageerAck ( 2019-11-11 13:46:33 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-11-10 18:02:58 +0100

Seen: 32 times

Last updated: 2 days ago