How to Delete Extra Pages in Excel (4 Methods).Read More: How to Delete a Sheet in Excel (5 Ways) So, now we can delete any worksheet from the workbook. Finally, if we right-click on the “ MARKS “ sheet again, we will see that the option “Delete” is now available.Use password 1234 If you are working with the practice workbook that we have added to this article. You must need to know the password of a protected workbook to unprotect that workbook. A new dialogue box named “Unprotect Workbook” will appear.In short: File > Info > Protect Workbook > Protect Workbook Structure.Select the option “Protect Workbook Structure” from the available options. Then select the option “Protect Workbook”.So, let’s look at the steps to solve this problem. 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. To illustrate this method, we have the following dataset with multiple worksheets in which the workbook is protected. If the workbook is protected, then we have to unprotect the workbook structure to enable the delete sheet option in excel.
Unprotect Workbook Structure While Delete Sheet in Excel Not Workingįirst and foremost, if the delete sheet in excel is not working we will check whether our workbook is protected or not. In the following sections, we will go through the solutions to both problems respectively.ġ. 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. To fix the problem of deleting sheets not working in excel, we will look into two solutions. 2 Solutions to Fix Delete Sheet Not Working in Excel