Can't delete worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-775158%22%20slang%3D%22en-US%22%3ECan't%20delete%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775158%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20right-clicking%20on%20a%20sheet%2C%20clicking%20delete%20and%20nothing%20happens.%26nbsp%3B%20The%20sheet%20is%20not%20protected.%26nbsp%3B%20I'm%20not%20sure%20what's%20happening.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20running%20Excel%20for%20Office%20365%20MSO%20v1902%20for%20Windows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-775158%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775197%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20delete%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775197%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382751%22%20target%3D%22_blank%22%3E%40Mike20878%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20the%20workbook%20is%20shared%20you%20won't%20be%20able%20to%20delete%20sheets.%20To%20turn%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eoff%20sharing%2C%20choose%20Tools%26gt%3BShare%20Workbook.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EOn%20the%20Editing%20tab%2C%20remove%20the%20check%20mark%20from%20'Allow%20changes%20by%20more%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Ethan%20one%20user%20at%20the%20same%20time'%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EClick%20OK%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHope%20that%20helps%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ENabil%20Mourad%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2552840%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20delete%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2552840%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382751%22%20target%3D%22_blank%22%3E%40Mike20878%3C%2FA%3E%26nbsp%3BI%20was%20researching%20this%20issue%20for%20myself.%20Running%20excel%20as%20admin%20then%20opening%20the%20book%20solved%20the%20issue%20for%20me.%20There%20is%20also%20a%20setting%20to%20always%20run%20the%20program%20as%20admin.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2938890%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20delete%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938890%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1104500%22%20target%3D%22_blank%22%3E%40DougFresh%3C%2FA%3E%26nbsp%3BPlease%20can%20you%20tell%20me%20how%20I%20can%20run%20Excel%20as%20admin.%20I%20have%20the%20same%20issue%20of%20not%20being%20able%20to%20delete%20sheets%20in%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2939414%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20delete%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2939414%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1211238%22%20target%3D%22_blank%22%3E%40Anamika1947%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20on%20Windows%20and%20have%20administrative%20user%20rights%3C%2FP%3E%0A%3CP%3EWin%20-%26gt%3B%20Excel%20-%26gt%3B%20Run%20as%20administrator%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2963672%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20delete%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2963672%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BSorry%2C%20but%20this%20did%20not%20make%20sense%20to%20me.%26nbsp%3B%20Tested%20and%20didn't%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2988746%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20delete%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2988746%22%20slang%3D%22en-US%22%3EHi.%20This%20didn't%20work%20for%20me%20either%3B%20at%20least%20in%20my%20case%2C%20having%20administrative%20rights%20makes%20no%20difference.%20This%20behavior%20only%20started%20after%20a%20recent%20Office%20365%20update.%20As%20there%20has%20been%20no%20other%20change%20in%20either%20my%20Windows%2010%20system%20setup%20or%20Office%20365%20or%20Excel%20usage%20patterns%2C%20I%20think%20this%20problem%20likely%20relates%20to%20a%20bug%20introduced%20via%20the%20recent%20update.%3C%2FLINGO-BODY%3E
New Contributor

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.

12 Replies

@Mike20878 

Hi

If the workbook is shared you won't be able to delete sheets. To turn
off sharing, choose Tools>Share Workbook.
On the Editing tab, remove the check mark from 'Allow changes by more
than one user at the same time'
Click OK

Hope that helps

Nabil Mourad

@Mike20878 I was researching this issue for myself. Running excel as admin then opening the book solved the issue for me. There is also a setting to always run the program as admin.

@DougFresh Please can you tell me how I can run Excel as admin. I have the same issue of not being able to delete sheets in Excel.

@Anamika1947 

If you on Windows and have administrative user rights

Win -> Excel -> Run as administrator

 

@Sergei Baklan Sorry, but this did not make sense to me.  Tested and didn't work.

Hi. This didn't work for me either; at least in my case, having administrative rights makes no difference. This behavior only started after a recent Office 365 update. As there has been no other change in either my Windows 10 system setup or Office 365 or Excel usage patterns, I think this problem likely relates to a bug introduced via the recent update.

@Mike20878 

I had the same problem. Right-click, Select All Sheets, choose Protect (and it will pop up that something is protected) enter password to Unprotect.  That's what finally worked for me.

@nabilmourad Where is Tools in Excel.. 

This didn't work for me
Simple convert the excel file to CSV Move all the sheets to another workbook and delete? That should do the trick
Disabling sharing worked for me.
I had the same problem, but the sheet was not obviously shared.
By doing SaveAs as a new sheet I was able to delete the unwanted sheets.
In my case the issue may have been caused because the file was in my shared google drive folder - so perhaps some kind of behinds the scenes sharing was in effect?