Forum Discussion
Can't delete worksheet
I'm right-clicking on a sheet, clicking delete and nothing happens. The sheet is not protected. I'm not sure what's happening. I'm running Excel for Office 365 MSO v1902 for Windows. Thanks...
I had this same issue tried the various suggestions to no avail. What worked for me was I closed the file then moved the file to my desktop opened it then I could delete the sheet like normal, I saved, closed the file and move it from my desktop back to its original location. I think grumbled0re may be right and it is shared on one of my shared drives, so moving it to my desktop moved it out of a shared location.
I think I'm in worse shape. Working in Microsoft Excel for Mac. Clicking on the Excel icon opens to the desktop about 30 of what I'm certain are corrupt sheets. Password or no password will not allow me to unprotect a sheet in order to delete it. I can close a sheet, but cannot delete it.
Edit > Sheet > Delete Sheet gets me to—
A workbook must contain at least one visible worksheet
