How to Prevent Sheet Deletion in an Excel Web Workbook
Question details
The user needs to prevent collaborators with edit access from deleting worksheets in an Excel for the web workbook, but Excel for the web has no password-based permission for this action.
- Product
- Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- A workbook owner shares an Excel workbook in a browser and wants to allow collaboration while stopping collaborators from deleting worksheets.
- Observed behavior
- Excel for the web only offers view-only or edit sharing levels. Editors can delete sheets, and there is no password-protected workbook structure option in the web version.
Check the current sharing level of the workbook in Excel for the web. If collaborators only need to review or fill specific cells, a view-only link may be enough; if they must edit, use a desktop spreadsheet application to protect the workbook structure.
Restrict Excel for the Web Sharing to View-Only
Use this when collaborators do not need to edit the workbook at all, because view-only access prevents sheet deletion and all other changes.
In Excel for the web, open the workbook and select the Share button in the upper-right corner.
Under the sharing link or invitation settings, select Anyone with the link can edit or the current edit permission.
Set the permission to View only, then select Apply or Save to update the sharing link.
Copy the updated link or send the invitation again so collaborators receive view-only access.
Protect the Workbook Structure in WPS Spreadsheets
Use this when collaborators still need to edit cells, but you must prevent them from adding, deleting, moving, or renaming worksheets.
Use WPS Spreadsheets to Lock Workbook Structure Without Excel Web Limits
Excel for the web cannot password-protect worksheets from deletion, but WPS Spreadsheets is a free, lightweight Office alternative with full .xlsx compatibility, a familiar ribbon interface, and workbook structure protection that prevents users from adding, deleting, moving, or renaming sheets.
Frequently Asked Questions
Can I set a password to prevent sheet deletion directly in Excel for the web?
No. Excel for the web does not have a password-protected workbook structure or sheet protection feature. You can only change the sharing permission to View only, or open the file in a desktop spreadsheet application such as WPS Spreadsheets and use Protect Workbook.
Will view-only access stop collaborators from deleting worksheets?
Yes. Users with view-only access cannot delete, add, move, or rename worksheets, but they also cannot edit cell data. Use this only when editing is not required.
How do I allow editing but still prevent sheet deletion?
Open the workbook in a desktop application that supports workbook structure protection, such as WPS Spreadsheets. Go to Review > Protect Workbook, check Structure, set a password, and save the file. Collaborators can then edit cells but cannot delete sheets.
Does workbook structure protection also lock cell editing?
Not by itself. Workbook structure protection prevents sheet operations like deleting, adding, moving, or renaming sheets. If you also need to lock cell contents, apply sheet protection separately.
Can Excel for the web open a workbook that has protected structure?
It can typically open the file, but structural protection may limit worksheet operations in the web version. Use a desktop spreadsheet app such as WPS Spreadsheets or Excel desktop when you need to manage or remove the protection.
