How to Fix Excel Worksheet Tabs Greyed Out After Unsharing
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.

- 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 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.
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.
Open your Excel workbook, navigate to the View tab on the top ribbon, and click on 'Normal' in the Workbook Views group.
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.
Right-click on any visible worksheet tab at the bottom and select 'Unhide'. Choose the missing sheets from the list and confirm.

Remove Sheet and Workbook Protection
Use this method if the 'Unhide' option is greyed out, which usually indicates that workbook protection is active.
Test in Excel for the Web and Restore Versions
If the issue is isolated to a specific Microsoft account or local cache, checking the file online can bypass local software bugs.
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. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your affected .xlsx file to view your missing tabs.
- 3. Save and Continue: Edit your recovered sheets and save the file normally. It will remain perfectly compatible with Excel.

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.




