Fix Disappearing Sheet Tabs in Excel for the Web
Question details
The user needs to access sheet tabs that flash or disappear in a workbook containing protected worksheets.

- Product
- Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- Opening a workbook with protected worksheets in Excel for the web.
- Observed behavior
- Sheet tabs may flash, disappear, or become unavailable in the browser, while desktop Excel may not show the same issue.
Check whether the affected workbook contains protected worksheets and whether you have permission to change their protection. If desktop Excel is available, open the same workbook there to compare the sheet tabs.
Compare a sample workbook with and without sheet protection
Use a sample workbook to check whether worksheet protection is associated with the missing tabs.
In Excel for the web, create a blank workbook and add several sheets using the plus button beside the sheet tabs.
Select a sheet and use the Review tab to protect it, if that option is available. Reopen the workbook in the browser and check whether its tabs flash or disappear.
If you have permission and the required password, use Review > Unprotect Sheet on the sample sheet. Check whether the tabs remain visible after reopening the workbook.
If desktop Excel is installed, open the affected workbook in the desktop app and check whether the same sheet tabs are visible.

Report the sheet-tab issue to Microsoft
Send Microsoft a reproducible example and diagnostic details when the tabs remain unavailable.
View and edit workbooks with WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel workbooks in WPS Spreadsheet for an easy transition, though it does not fix Excel for the web.

Frequently Asked Questions
Does worksheet protection always make sheet tabs disappear?
No. Protection restricts editing, but disappearing tabs are not an expected result in every workbook. Test a sample workbook with protected and unprotected sheets to help isolate the issue.
What can I do if the tabs work in desktop Excel but not in the browser?
Use desktop Excel to access the sheets if it is available, then report the browser-specific behavior to Microsoft with a sample workbook and steps to reproduce it.
Can I unprotect a sheet to test the problem?
If you are authorized and have any required password, use Review > Unprotect Sheet. Test on a sample workbook and check whether the tabs remain visible after reopening it.
What should I send Microsoft Support?
Provide a sample workbook, reproduction steps, the browser and version, any available Excel for the web build information, and screenshots or a screen recording. Share files through the private channel support provides.




