Document Editing Problems

How to Fix Excel Worksheet Tabs Greyed Out After Unsharing

Khadija KhanKhadija Khan Oct 23, 2026 872 views

Question details

The user is unable to view certain Excel worksheet tabs because they appear greyed out or missing, specifically after unsharing a workbook and closing it without saving.

How to Fix Excel Worksheet Tabs Greyed Out After Unsharing a Workbook
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to access previously selected worksheet tabs after removing the shared workbook status and exiting the file without saving.
Observed behavior
Specific worksheet tabs are greyed out or unavailable. The tabs may flash briefly during loading, and the issue appears tied to the specific Microsoft user account, as other users logging in on the same device can view the tabs normally.
Before you start

Before modifying workbook settings or reverting versions, create a copy of your current Excel file to ensure no recent data is accidentally lost during the troubleshooting process.

Solution 1Recommended

Check Unhide Options and Normal View

This is the most common fix for tabs that have been accidentally hidden by view settings or glitchy window layouts.

Sometimes unsharing a workbook triggers a display glitch that hides the active window or specific sheets. Re-enabling the normal view and checking the unhide dialog can instantly restore visibility.

1
Switch to Normal View

Open your Excel workbook, navigate to the View tab on the top ribbon, and click on 'Normal' in the Workbook Views group.

2
Unhide the Workbook

Still on the View tab, look at the Window group. If the 'Unhide' button is clickable, click it, select your workbook from the list, and click OK.

3
Unhide Specific Sheets

Right-click on any visible worksheet tab at the bottom and select 'Unhide'. Choose the missing sheets from the list and confirm.

Check Unhide Options and Normal View
View Reset: Switching views forces Excel to refresh its display rendering, which often resolves temporary graphical glitches.
Free Microsoft Office alternative

Bypass Account Glitches with WPS Office

If your Excel tabs remain greyed out due to persistent Microsoft account syncing issues or local software bugs, try opening your file in WPS Office. It is a lightweight, fully compatible alternative that can open your spreadsheets without being restricted by Microsoft account caching errors.

  1. 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your device.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your affected .xlsx file to view your missing tabs.
  3. 3. Save and Continue: Edit your recovered sheets and save the file normally. It will remain perfectly compatible with Excel.
Highly compatible with Microsoft Excel .xls and .xlsx file formatsOperates independently of Microsoft account syncing, avoiding profile-specific bugsLightweight installation and fast loading speedsFamiliar spreadsheet interface requires zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why do worksheet tabs turn grey after I unshare an Excel workbook?

This can happen due to an application glitch where the custom view or window state linked to your specific Microsoft account becomes corrupted when the file is unshared and closed simultaneously without saving.

What should I do if the 'Unhide' button in Excel is also greyed out?

If the 'Unhide' option is disabled, it usually means the workbook structure is protected. Go to the Review tab and select 'Unprotect Workbook'. You may need the password if the owner locked it.

Can clearing my Office cache fix account-specific missing tabs?

Yes. Since the visibility of the tabs may depend on your local user account settings, signing out of your Microsoft account in Excel, clearing the Office cache, and signing back in can often refresh the application state and restore the missing tabs.