Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

[Fixed!] Delete Sheet Not Working in Excel (2 Solutions)

In this tutorial, we’ll look at how to fix the problem when the delete sheet not working in Excel. While working with a workbook that consists of multiple worksheets, suddenly we might need to delete any particular worksheet. However, the option to delete any sheet does not always function. Sometimes we have to take a few steps to enable the delete sheet option. Throughout this article, we will demonstrate two solutions to this problem with a unique dataset.


Download Practice Workbook

You can download the practice workbook from here.


2 Solutions to Fix Delete Sheet Not Working in Excel

To fix the problem of deleting sheets not working in excel, we will look into two solutions. The most probable reason behind the delete sheet not working in excel might be the workbook that you are using is protected with a password or shared with other users. In the following sections, we will go through the solutions to both problems respectively.


1. Unprotect Workbook Structure While Delete Sheet in Excel Not Working

First and foremost, if the delete sheet in excel is not working we will check whether our workbook is protected or not. If the workbook is protected, then we have to unprotect the workbook structure to enable the delete sheet option in excel. To illustrate this method, we have the following dataset with multiple worksheets in which the workbook is protected.

Unprotect Workbook Structure While Delete Sheet In Excel Not Working

Here, if we right-click on the worksheet named “MARKS” we will notice that the option “Delete” is grayed out which means this option is not functioning.

Unprotect Workbook Structure While Delete Sheet In Excel Not Working

So, let’s look at the steps to solve this problem.

STEPS:

  • First, go to the File tab.

Unprotect Workbook Structure While Delete Sheet In Excel Not Working

  • Next, select the option Info.
  • Then select the option “Protect Workbook”.
  • Click on the drop-down icon. Select the option “Protect Workbook Structure” from the available options.
  • In short: File > Info > Protect Workbook > Protect Workbook Structure

Unprotect Workbook Structure While Delete Sheet In Excel Not Working

  • A new dialogue box named “Unprotect Workbook” will appear.
  • Insert the password in the input box.
  • Click on OK.

NOTE:

You must need to know the password of a protected workbook to unprotect that workbook. Use password 1234 If you are working with the practice workbook that we have added to this article.

  • Finally, if we right-click on the “ MARKS “ sheet again, we will see that the option “Delete” is now available. So, now we can delete any worksheet from the workbook.

Read More: How to Delete a Sheet in Excel (5 Ways)


Similar Readings:


2. Turn off Sharing Worksheet When Delete Sheet Not Working in Excel

Another reason why the delete sheet in excel isn’t working is that the worksheet you’re using is shared. So, to delete any sheet from any shared workbook you need to unshare the workbook first. To illustrate this solution, we will use the following dataset with multiple worksheets.

Turn off Sharing Worksheet When Delete Sheet Not Working In Excel

When we right-click on the worksheet “Turn Off Sharing” we can see the grey color in the option “Delete”, indicating that it is not active.

Turn off Sharing Worksheet When Delete Sheet Not Working In Excel

The process of sharing a workbook is a little bit complex. So, for convenience to understand this solution better, first we will show how to share a workbook then we will show how to unshare that workbook to enable the delete sheet option.

So, let’s see the steps to perform this method.

STEPS:

  • Firstly, go to the File tab.

Turn off Sharing Worksheet When Delete Sheet Not Working In Excel

  • Secondly, click on Options.

Turn off Sharing Worksheet When Delete Sheet Not Working In Excel

  • Thirdly, a new dialogue box will open. Select the option “Customize Ribbon”. Click on the drop-down icon of the option “Choose commands from”. Select the option “All Commands” from the available options.

  • Next, scroll down the option and select the option “Share Workbook (Legacy)”. Also, click on the option New Tab.

  • Then a new tab “New Tab (Custom)” will appear in the ribbon options.
  • Select “New Tab (Custom)” and click on Rename.
  • The above command will open a dialogue box named “Rename”.
  • Insert the name of the tab “Sharing” in the input box “Display name”.
  • Now, click on OK.

  • Similarly, rename the option “New_Group (custom)” to “Sharing Workbook” and click on Add.

Turn off Sharing Worksheet When Delete Sheet Not Working In Excel

  • Now we can see a new option “Share Workbook (Custom)” in the ribbon options.
  • Then, press OK.

  • After the above actions, we can see that a new tab named Sharing is visible now.

  • Now to share the workbook go to the Sharing tab and select the option “Share Workbook (Legacy)”.

Turn off Sharing Worksheet When Delete Sheet Not Working In Excel

  • A new dialogue box will appear. Check the option shown in the image below and press OK.

  • So the above command shares our workbook with other users. If we right-click on the sheet “Turn Off Sharing” we will see that the option Delete is grayed out which means we can not delete any sheet from a shared workbook.

  • After that, we need to unshare this workbook to solve this problem.
  • So, to do this go to the Review Select the option “Unshare Workbook” from the Protect section of the Review tab.

Turn off Sharing Worksheet When Delete Sheet Not Working In Excel

  • Lastly, right-click on the sheet “Turn Off Sharing” Now we can see that the option Delete is available again.

Turn off Sharing Worksheet When Delete Sheet Not Working In Excel

Related Content: Shortcut to Delete Sheet in Excel (5 Quick Examples)


Conclusion

In conclusion, this tutorial demonstrates two solutions to fix the problem of deleting a sheet in excel not working. To put your skills to the test, download the practice worksheet included in this article. Leave a comment in the box below if you have any questions. Our team will try to reply to your message as quickly as possible. In the future, keep your eyes peeled for more innovative Microsoft Excel solutions.


Related Articles

Mukesh Dipto

Mukesh Dipto

Hi there! I am Mukesh Dipto. I graduated with a bachelor's degree in engineering. Currently, I am working as a technical content writer in ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include sports and meeting new people. I also enjoy sports. My favorite sports are football (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo