Office Settings & Configuration

Fix Disappearing Sheet Tabs in Excel for the Web

Rana GarciaRana Garcia Nov 14, 2026 869 views

Question details

The user needs to access sheet tabs that flash or disappear in a workbook containing protected worksheets.

Fix Disappearing Sheet Tabs in Excel for the Web
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.
Before you start

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.

Solution 1Recommended

Compare a sample workbook with and without sheet protection

Use a sample workbook to check whether worksheet protection is associated with the missing tabs.

1
Create a sample workbook

In Excel for the web, create a blank workbook and add several sheets using the plus button beside the sheet tabs.

2
Test sheet protection

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.

3
Compare with an unprotected sheet

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.

4
Compare with desktop Excel

If desktop Excel is installed, open the affected workbook in the desktop app and check whether the same sheet tabs are visible.

Compare a sample workbook with and without sheet protection
Protection and web features: Worksheet protection restricts editing, and some Excel features differ between the web and desktop apps. Unprotect a sheet only if you are authorized to do so.
Free Microsoft Office alternative

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.

Open and navigate workbook sheets in WPS SpreadsheetCompatible with Microsoft Excel formats, including XLSXUse a familiar spreadsheet interfaceMove existing Office files into a lightweight suite
QA img-9

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.