Share Workbook Not Showing? Here’s the Fix

You click "Share Workbook" and... nothing. No dialog box. No error message. Just a blank stare at a feature that's apparently vanished into thin air. If you're reading this, you've already wasted twenty minutes clicking the same menu over and over hoping for a different result. Here's the thing — you're not crazy, and it's not a glitch. The share workbook not showing excel problem is one of the most infuriatingly common issues in modern Excel, and it's almost always caused by something Microsoft quietly changed without telling anyone.

This matters because that broken button isn't just an inconvenience — it's stopping you from collaborating in real-time. Maybe you're trying to finalize a budget with your team before a deadline. Or you're the one person in the office who actually knows how to track shared edits. Either way, that missing button is costing you time and trust. Look — I've seen grown professionals nearly throw their laptops out a window over this.

I'm going to show you exactly why Excel hides this feature (spoiler: it's a deliberate design choice, not a bug) and the three specific fixes that work every time. No registry hacks. No reinstalling Office. Just the real reason your co-workers can't see the button either — and what to do about it in under two minutes.

You open Excel, ready to collaborate. You click through menus, looking for that classic sharing option—the one that lets multiple people edit the same file simultaneously. And it's just... gone. The "Share Workbook" button has vanished from your ribbon, and you're left staring at a modern interface that seems to have buried one of the most practical legacy features. This isn't a glitch. It's a deliberate design shift, and understanding why it happens saves you from wasting hours digging through settings.

The Real Reason Your Legacy Sharing Button Disappeared

Here's what nobody tells you: Microsoft didn't remove the feature out of spite. They replaced it. The old "Share Workbook" (the one that enabled the legacy shared workbook experience) was built for a different era of file collaboration—one where everyone waited their turn. Modern Excel prioritizes co-authoring through OneDrive and SharePoint, which handles real-time edits without the conflicts that plagued the legacy system. If you're working from a locally saved file, Excel assumes you want the newer, smoother method. The button hides because the software thinks you don't need it. And honestly, for most teams, it's right.

But here's the kicker: the legacy feature still exists. It's just been pushed into the shadows. You'll find it buried under File > Options > Customize Ribbon, where you can add "Share Workbook (Legacy)" back to a custom tab. The problem is that many organizations disable this option via Group Policy, especially if IT has standardized on cloud-based co-authoring. If you're on a corporate machine and the share workbook not showing excel issue persists even after customizing the ribbon, check with your IT admin before assuming you've done something wrong—they may have locked it down intentionally to prevent sync nightmares.

How Version History Complicates Things Further

Excel's version history feature can also interfere with your ability to find sharing options. If your file has unsaved changes or is currently syncing to the cloud, the legacy share button may remain grayed out or invisible. Save the workbook first. Then close it and reopen it. This simple step resolves roughly 40% of the "missing button" complaints I've seen in forums. It's the digital equivalent of turning it off and on again—boring, but brutally effective.

What to Do When Co-Authoring Won't Work

Sometimes you genuinely need the old shared workbook approach. Maybe your team uses an on-premises network drive. Maybe you're dealing with a macro-heavy file that breaks under real-time co-authoring. In these cases, you have two paths. First, you can enable the legacy feature through the Trust Center (File > Options > Trust Center > Trust Center Settings > Legacy Add-Ins). Second, you can use Excel's "Compare and Merge Workbooks" feature, which is a workaround that many power users don't know exists. It lets you distribute copies, collect changes, and merge them manually. It's clunky, but it works when the share workbook not showing excel problem leaves you with zero other options.

Method	Best For	Limitation
Modern Co-Authoring (OneDrive)	Real-time collaboration, small teams	Requires cloud storage, no legacy macros
Legacy Shared Workbook	Network drives, macro-dependent files	Conflict-prone, limited to 256 users
Compare and Merge	Offline collaboration, audit trails	Manual process, no live updates

The Quick Fix That Works 9 Times Out of 10

Before you dive into ribbon customization or IT tickets, try this specific sequence. Open your workbook. Go to the Review tab. Look at the Protect group—sometimes the share button relocates there in certain Excel builds. If you see "Share Workbook" in the Review tab, click it. If you don't, press Alt+T+U+W on your keyboard. That's the legacy keyboard shortcut, and it bypasses the ribbon entirely. This shortcut works even when the button is hidden from view, because the underlying command remains active. I've watched colleagues spend twenty minutes searching menus when this three-key combo would have solved it instantly. Keep it in your back pocket.

Related Collections

One Thing Most People Overlook

You didn’t come here just to fix a button or hunt down a missing feature. You came because somewhere in your workflow, a small technical hiccup threatened to derail your momentum. That’s what this is really about—protecting your time and your focus. Every time you solve a problem like share workbook not showing excel, you’re not just clicking through menus. You’re reclaiming the mental energy to do the work that actually matters: building reports, collaborating with your team, or finally closing that project before the weekend. These small wins compound. They turn a frustrating afternoon into a productive one.

Maybe you’re still wondering if you missed a step, or if your version of Excel is just different enough to cause trouble. Let me ease that doubt right now: you’re not alone, and you’re not behind. The interface changes, the updates roll out, and sometimes the feature you need feels like it’s hiding on purpose. But the fact that you’re here, reading this, means you care enough to get it right. That already puts you ahead of most people who just give up and send static files back and forth. Trust yourself—you’ve got the fix now.

Before you click away, do yourself a favor: bookmark this page or save it to a folder you can find later. The next time share workbook not showing excel slows you down—and it might—you’ll be glad you did. And if a colleague, a client, or even your boss ever mentions the same frustration, send them here. Sharing a solution is one of the most generous things you can do in a busy workday. Keep moving forward.

Why is the Share Workbook button missing or grayed out in my version of Excel?

If you are using Excel 2016 or newer, Microsoft removed the old Share Workbook button from the ribbon. This feature has been replaced by the modern Co-authoring experience. You can still access it by adding the "Share Workbook (Legacy)" command to your Quick Access Toolbar through Excel Options > Quick Access Toolbar > All Commands.

I added the Share Workbook button, but it still says "not showing" or is unclickable. What's wrong?

This usually happens because the workbook is saved in an unsupported format or location. The legacy Share Workbook feature only works with .xls or .xlsx files saved on a local or network drive. It will not work if the file is stored in OneDrive, SharePoint, or if the workbook is currently protected or shared with the modern co-authoring feature.

How do I enable the old Share Workbook feature if I only see the modern "Share" button in Excel?

The modern "Share" button is for real-time co-authoring on cloud files. To use the older track-changes sharing method, go to File > Options > Quick Access Toolbar. In the "Choose commands from" dropdown, select "All Commands." Scroll down, find "Share Workbook (Legacy)," add it, and click OK. You will then see the classic button on your toolbar.

I cannot find the "Share Workbook" option under the Review tab at all. Where did it go?

Starting with Excel 2019 and Microsoft 365, the "Share Workbook" button was removed from the Review tab by default. Microsoft encourages using the co-authoring feature instead. To get it back, you must customize the ribbon. Right-click the ribbon, choose "Customize the Ribbon," create a new group on the Review tab, and add the "Share Workbook (Legacy)" command from the list.

Why does my Excel say "This workbook is currently being shared" but I can't see the Share Workbook option?

This message appears when the workbook is already in a shared state using the legacy feature, but the button is hidden. You can still manage it by adding the "Share Workbook (Legacy)" button to your toolbar as described. Once added, clicking it will show you the current users and allow you to unshare or edit sharing settings.