Why Is Show Changes Greyed Out In Excel? | Make It Clickable

You click Show Changes and nothing happens. The button looks faded. No pane. No history. It feels like Excel is refusing to cooperate.

Most of the time, it’s not a bug. It’s Excel telling you the workbook doesn’t meet the rules for this feature. Once you line those rules up, the button usually lights up right away.

This walkthrough keeps it practical: what blocks the button, how to spot the blocker in seconds, and what to change without breaking your file.

What “Show Changes” Needs Before It Will Turn On

Show Changes is built around modern collaboration. It’s meant for a workbook that lives in the Microsoft cloud and is being saved continuously while people edit.

So the feature tends to stay disabled when any of these basics are missing:

• The workbook isn’t stored in OneDrive or SharePoint. Local files often won’t qualify.
• AutoSave is off. The feature is tied to continuous saving in the cloud.
• You don’t have edit permission. Read-only access can block the changes pane.
• The workbook is in a state that blocks collaboration. Some protection settings and legacy sharing modes can get in the way.

If you only take one idea from this page, take this: the button usually turns back on when the workbook is cloud-based, editable, and saving live.

Show Changes Greyed Out In Excel On Desktop And Web

The fastest way to debug this is to stop guessing and check three signals: file location, AutoSave, and access level.

Step 1: Confirm Where The File Lives

Open the workbook and look at its location in the title bar or under File > Info. If it’s on your hard drive, a USB stick, or a mapped drive, that alone can keep Show Changes disabled.

Fix: Save a new copy to OneDrive or SharePoint. Use File > Save As, then pick a OneDrive or SharePoint folder you can edit.

Step 2: Check The AutoSave Toggle

In Excel for Microsoft 365, AutoSave typically sits at the top-left of the window. If it’s off, turn it on.

If the toggle isn’t there, or it refuses to switch on, that usually points to one of these:

• The workbook is not in OneDrive or SharePoint.
• You’re in an older Excel version or a license that doesn’t include the feature set.
• The workbook is in a mode that disables AutoSave (compatibility mode, restricted editing, or certain workbook settings).

Microsoft’s AutoSave notes explain the cloud requirement and common reasons the toggle can be unavailable. Turn on AutoSave in Microsoft 365 apps lays out what AutoSave works with and what can block it.

Step 3: Confirm You Have Edit Access

If you opened the file from an email attachment, Teams chat, or a link, you might be viewing a copy or a read-only version.

Quick checks:

• Look for “Read-Only” in the title bar.
• Try typing in an empty cell. If Excel blocks edits, your access level is the limiter.
• Use Share (top-right) to see if you’re listed as a viewer.

Fix: Request edit access, or open the file from the original OneDrive/SharePoint location where you have edit permission.

Workbook States That Commonly Disable The Button

If the file is in the cloud and AutoSave is on, but Show Changes is still greyed out, the workbook is often in a “blocked for collaboration” state. This is where small details matter.

Protected Workbook Or Protected Sheet

Protection can prevent certain editing-related features from running cleanly. If the workbook structure is protected, or sheets are protected with restrictions, Excel may limit tools that rely on tracking edits.

What to try:

• Go to Review and check Protect Sheet / Protect Workbook.
• If protection is on, remove it (you may need the password).
• Save, close, and reopen the file from the cloud location.

Legacy “Shared Workbook” Mode

Excel has an older sharing system often called “Shared Workbook (Legacy).” Files set up that way can behave differently than modern co-authoring.

If you see settings tied to legacy sharing, switch to modern co-authoring instead:

• Move the file to OneDrive/SharePoint.
• Use the Share button to invite editors.
• Keep AutoSave on while editing.

Local Copy Confusion

This one is sneaky. You think you’re editing the “real” workbook, but you’re actually editing a local copy downloaded from the cloud. That copy can open with AutoSave off and leave the button disabled.

Fix: Open the workbook from OneDrive on the web or SharePoint, then choose “Open in app” so Excel connects to the cloud file, not a detached download.

Compatibility Mode Or Older File Format

If the file is in an older format or compatibility mode, some modern collaboration features can drop out. You may spot “Compatibility Mode” in the title bar.

Fix: Save as a modern workbook format (.xlsx) in OneDrive/SharePoint, then reopen.

Co-Authoring Not Actually Active

Co-authoring is more than sharing a link. Excel needs to be actively connected to the cloud workbook so changes save live. If co-authoring isn’t active, Show Changes may stay disabled.

Signs co-authoring is active:

• AutoSave is on and stays on.
• You can see other editors (icons or initials) when they’re in the file.
• Edits sync without manual saving.

Fast Diagnosis Table: What You See And What To Fix

Use this as a quick pinboard. Find the symptom that matches your workbook, then apply the matching fix.

Make The Button Work In A Real Team File

If you’re setting this up for a shared workflow, a clean setup beats troubleshooting later. This is a reliable pattern that tends to keep Show Changes available.

Use One Cloud Copy As The Source Of Truth

Create the workbook directly in OneDrive or SharePoint, or move it there once and stop emailing attachments back and forth. Attachments produce copies, and copies break the “single shared workbook” idea.

Invite Editors Through The Share Button

Open the workbook from its cloud folder, then use Share to invite people. This reduces weird “viewer vs editor” states that can block the changes pane.

Keep AutoSave On While Editing

AutoSave is not just convenience here. It’s part of the contract for collaboration features. If AutoSave is off because someone opened a local copy, you can end up with edits that never show in the change tracking view you expect.

Limit Heavy Locks While People Are Editing

Sheet protection and workbook structure protection can still be useful. Use them when needed, then lift them during active editing sessions if they block collaboration tools.

Why Is Show Changes Greyed Out In Excel? In Shared Files

When the workbook is shared and the button is still greyed out, the cause is almost always one of these three:

• Someone is editing a non-cloud copy. It looks shared, but it isn’t the same file.
• AutoSave is off for the person testing the feature. The workbook may be cloud-stored, yet the app session is not connected cleanly.
• The person testing only has view access. They can open the file, but Excel treats their session as read-only.

One quick team test works well: have two editors open the workbook from OneDrive/SharePoint, confirm AutoSave is on for both, then make small edits in different cells. If edits sync live, you’re in the right mode. If they don’t, fix the connection first.

When “Show Changes” Is Available But Looks Empty

Sometimes the button is clickable and the pane opens, yet you still feel stuck because you don’t see what you expected.

It Only Shows Recent Changes

The changes pane is meant for recent activity, not a full audit log of everything that ever happened in the workbook. If you need older edits, version history is usually the better tool inside Microsoft’s cloud file system.

Microsoft’s own notes on the feature call out the “recent changes” behavior and point you to version history for older edits. Get help with Show Changes in Excel explains what the pane shows and what to use when you need a longer window.

Filters Can Hide What You’re Looking For

The changes pane can filter by person, cell range, or type of change. If it looks blank, clear filters and try again. Also try making one fresh edit after clearing filters, then check the pane right away.

You’re Expecting Comment History

Show Changes is about workbook edits, like cell values and formulas. Comments and threaded conversations have their own tools. If your goal is “who said what,” you may be in the wrong feature.

Second Table: A Quick Path To The Fix

If you want a straight shot to a working state, follow the row that matches your situation.

A Clean Checklist Before You Walk Away

Once the button is clickable, lock in the setup so it stays that way.

• Store the workbook in OneDrive or SharePoint, not on a local drive.
• Open it from its cloud folder, not from an attachment download.
• Confirm AutoSave stays on after you reopen the file.
• Verify you have edit permission, not view-only access.
• Use protection settings with care during active editing.

Do those five things and Show Changes usually behaves like a normal button again.

Send us your feedbackTell us what you thought about this post

Name * Email *

Your comment *

Quick check — what is …? *

Send feedback