Prevent Other Users from Hiding Excel Sheets During Co-Authoring
Question details
Users need a way to prevent other co-authors from hiding or unhiding worksheets, as these actions currently affect everyone viewing the shared file.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Excel workbook where multiple users need different views of the data without disrupting each other.
- Observed behavior
- When one user hides a worksheet, the tab unexpectedly disappears for all other users currently viewing the co-authored workbook.
Ensure you have the necessary administrative or owner permissions for the shared Excel file, as restricting structural changes will require applying a workbook-level password.
Protect the Workbook Structure
Use the Protect Workbook feature to lock the structure of the file, preventing all users from hiding, unhiding, adding, or deleting worksheets.
Currently, Excel does not offer a personal view for worksheet visibility. Any structural change, such as hiding a sheet, is synchronized globally for all co-authors. The most effective workaround is to restrict anyone from altering the workbook's structure.
Open your shared Excel workbook and click on the 'Review' tab located in the top ribbon.
Click on 'Protect Workbook' in the Protect group. A dialog box will appear.
Ensure the 'Structure' checkbox is ticked. Enter a password (optional but recommended) to prevent unauthorized users from disabling the protection, then click 'OK'.
Use Separate Linked Workbooks
Divide workflows into independent personal workbooks connected to a central master file to avoid interfering with each other's views.
Experience Seamless Document Collaboration with WPS Office
If you frequently encounter limitations with Microsoft Office's shared features, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative with comprehensive spreadsheet protection tools designed to keep your collaborative work secure and organized.
Frequently Asked Questions
Can I use Custom Views to hide sheets just for myself?
No. Custom Views in Excel only save display settings for individual worksheets, such as hidden rows, hidden columns, cell selections, and filters. They cannot save workbook-level structural settings like hidden sheets.
Do Sheet Views in Excel for the Web fix this issue?
No. Sheet Views are designed to allow individuals to create custom filters and sorting rules without disrupting other co-authors. However, hiding a worksheet entirely is a structural change that still affects all users in the session.
How can I request Microsoft to add a personal sheet visibility feature?
You can submit a feature request directly to Microsoft by opening Excel and navigating to Help > Feedback > 'I have a suggestion'. Alternatively, you can use the Feedback Hub app built into Windows.
