Forum Discussion
Mike20878
Jul 26, 2019Copper Contributor
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...
nabilmourad
MVP
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
grumbled0re
Jan 06, 2022Copper Contributor
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?
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?
- jgoveaMar 23, 2022Copper Contributor
Save As features worked for me. I was able to delete the unwanted sheet.