Track Changes in Excel Online: View and Review Edits

How-to basics · Updated November 20, 2026

To track edits in Excel Online, open the workbook and choose Review > Show Changes. Excel for the web records cell edits automatically for a supported workbook; there is no separate Track Changes switch to turn on. The Changes pane shows who changed a cell, when it changed, and—when available—its previous value. Use it to inspect recent edits, and use Version History if you need to find or restore an older workbook version.

What You’ll Need

  • A browser and an internet connection, with Excel for the web open and signed in to your Microsoft account.
  • The workbook saved in OneDrive or SharePoint. Excel for the web works with cloud files, and changes need to sync to the file for collaborators to see them.
  • Permission to open the workbook. To make edits yourself, you need edit access; view-only access lets you inspect the workbook but not change its cells.
  • A current workbook format such as .xlsx. If the file is in an older or unusual format, save a supported copy before relying on coauthoring and change history.

Step-by-Step

  1. Open the cloud workbook. Go to Microsoft 365 or your organization’s SharePoint or OneDrive site, sign in, and open the workbook in Excel for the web. If the file is open in desktop Excel, use the option to open it in the browser, or locate the cloud copy in OneDrive or SharePoint. Confirm that you have the right file: two similarly named copies can have different histories.
  2. Check that the workbook is saved online. Look for the workbook name at the top of the page and check that Excel shows it is saved or up to date. A file stored only on your computer cannot provide the same shared, cloud-based editing experience. If needed, upload or save a copy to OneDrive or SharePoint, then open that copy in the browser. Do not move or rename a shared file without considering whether collaborators rely on its existing link.
  3. Open the Review tab. Select Review on the ribbon. If the ribbon is collapsed, expand it using the ribbon control near the top of the page. In some layouts, the tab or command may be tucked into an overflow menu; widen the browser window or expand the ribbon if you cannot see it.
  4. Select Show Changes. Choose Review > Show Changes. Excel opens the Changes pane, usually along the right side of the workbook. You do not need to enable a tracking setting first. Opening this pane displays the recent edit history that Excel has available; it does not start a new tracking period or change what other people can edit.
  5. Review the listed edits. Entries identify an editor and the time of an edit, and usually show the affected cell and its new value. Select an entry to move to the relevant cell and inspect it in context. Where Excel has retained the information, the pane also shows the previous value. Check the sheet name and cell address before drawing a conclusion, especially if the workbook contains repeated labels or similar tables.
  6. Narrow your check to a cell or sheet. To investigate one cell, right-click it and choose Show Changes, if that command appears in the context menu. This is a quick way to focus on that location rather than scan a long list. You can also select the relevant worksheet before opening the Changes pane. Availability and wording can vary with the workbook and the current web interface.
  7. Confirm an edit before acting on it. Compare the listed cell and value with the worksheet, and ask the editor if the change is unclear. Show Changes is an audit aid, not an approval workflow: it does not automatically accept, reject, or lock individual edits. If a change should be reversed, make a deliberate correction or consult Version History rather than assuming the pane has a one-click restore for that cell.
  8. Close the pane when finished. Use the close control on the Changes pane to return to the full worksheet view. Closing it does not disable tracking or erase the history. Later, reopen it with Review > Show Changes to inspect available edits again.
  9. Use Version History for older or broader changes. Select the workbook name at the top of the Excel web page and choose Version History, when available. Alternatively, open the file’s version history from its OneDrive or SharePoint location. Review the dated versions to find a state from before an unwanted change. If you need to restore one, first consider saving or downloading a copy of the current version; restoring an earlier version affects the shared workbook, not just the cell you are examining.

The key distinction is that Excel for the web’s current feature is called Show Changes. It is not the older desktop Track Changes command associated with the legacy Shared Workbook feature. In the web app, you generally view automatically recorded recent changes rather than switch on that legacy mode.

Common Mistakes

  • Looking for a Track Changes toggle. The web interface does not require the old-style enable button. Choose Show Changes to display the available change list; the feature name is easy to confuse with the legacy desktop command.
  • Expecting every kind of edit to appear. Show Changes is primarily for edits to cell values and formulas. Formatting changes and edits to charts, shapes, objects, PivotTables, or changes made through some tools may not be represented as individual entries. If the worksheet looks different but the pane has no matching record, check Version History and ask the editor.
  • Assuming the pane is a permanent, complete audit log. Excel’s Changes view is limited to recent history—Microsoft documents a window of up to 60 days—and it is not a substitute for a formal compliance or audit system. If a change is older, missing, or outside the feature’s coverage, look at saved versions or your organization’s retention tools.
  • Opening the wrong copy. A local download, email attachment, or duplicate workbook may not contain the same collaborators’ recent changes as the OneDrive or SharePoint original. Check the file location and name before troubleshooting the pane.
  • Expecting to undo another person’s edit from the history entry. Show Changes explains what happened; it is not a list of approvals or a guaranteed per-entry rollback control. Editing the cell now creates a new change. Version History is the better option when you need to compare or recover a broader earlier state.

Tips

  • Use a shared cloud copy for collaboration. Store the working file in OneDrive or SharePoint and share that link with collaborators. This avoids parallel attachments whose edits are hard to reconcile and gives Excel a common file in which to record changes.
  • Ask collaborators to use their own accounts. When people share a generic login, the editor identity may not clearly distinguish who made an edit. Individual Microsoft accounts make the names in the Changes pane more useful.
  • Check the cell address, not just the displayed text. A repeated value such as “Complete” may appear in many rows. Confirm the worksheet, address, and surrounding labels before deciding that a particular edit is the one you need.
  • Review frequently when a workbook is busy. Checking changes soon after a collaboration session makes it easier to ask what an ambiguous update means while its context is fresh. It also avoids relying on the pane for edits that may age beyond its history window.
  • Keep a copy before a major recovery. Before restoring an earlier workbook version, download or duplicate the current version if you may need its newer content. A full-version restore can affect other people’s work, so coordinate first when the workbook is shared.
  • Use comments for discussion, not as a substitute for history. If you need a decision or explanation, add a comment or contact the editor. A change record can show a cell value and editor, but it may not explain why the change was made.

Troubleshooting

Show Changes is missing or unavailable: Confirm that you are in Excel for the web, not merely viewing a downloaded copy or an unsupported preview. Sign in with an account that can open the workbook, expand the ribbon, and look under Review. If the file is in an old format or has compatibility restrictions, save a supported .xlsx copy in OneDrive or SharePoint and reopen it. Your organization may also limit access or sharing features; contact its Microsoft 365 administrator if the command remains unavailable.

The pane opens but appears empty: Make sure you opened the same cloud file where the edits were made. Check whether the changes were made within the recent history window and whether they were cell-value or formula edits that Show Changes supports. Formatting, objects, and certain workbook operations may not appear as ordinary cell-edit entries. Refresh the browser after confirming the file has finished saving, then open the pane again.

An editor’s name or previous value is missing: Some change details may not be available for every edit. Verify that collaborators signed in with individual accounts, and check the relevant version in Version History for more context. If the editor is still unclear, ask the people who had access rather than treating a missing name as proof that no one made the change.

A recent edit is not visible yet: Ask the editor to confirm that Excel finished saving, then refresh your browser or close and reopen the workbook. Make sure both people are working in the same file, not separate downloaded copies. If the edit was made through a feature that does not appear in Show Changes, compare versions or inspect the affected worksheet directly.

You need to recover a deleted value: First inspect Version History and identify a version from before the deletion. Preserve the current copy, then decide whether to restore the older version or manually copy the needed value back. Restoring a version can replace other newer content, so for a single cell it may be safer to copy only that cell’s old value after checking its surrounding formulas and dependencies.

Frequently Asked Questions

Do I have to turn on Track Changes in Excel Online?
No separate switch is required for the current web feature. Open Review > Show Changes to see the recent edits Excel has recorded. That command opens the history pane; it is not the legacy Track Changes setting.

How far back can I see changes?
Show Changes covers up to 60 days of recent changes, according to Microsoft’s feature guidance. Older edits may no longer appear there. Use Version History or an organization’s retention and audit tools when you need to investigate older activity.

Can I see who changed a particular cell?
Usually, yes: select the relevant entry in the Changes pane to identify its editor and inspect the cell and time. Details can be limited for some edits, and shared accounts can make the identity less useful. Right-clicking a cell and choosing Show Changes, when available, can help focus the view.

Does Show Changes record formatting changes?
Do not rely on it as a complete record of formatting or every workbook operation. It is designed mainly to show cell-value and formula edits; formatting, charts, objects, and certain other changes may not appear as individual records. Version History can help compare broader workbook states.

Can I reject or undo an edit from the Changes pane?
The pane is for reviewing, not accepting or rejecting edits. You can edit the cell to correct it, which creates a new edit, or use Version History to restore an earlier workbook state. Preserve the current version first if newer changes may be needed.

Is Excel Online’s Show Changes the same as legacy Track Changes?
No. Show Changes is the current change-review feature for Excel for the web and supported Microsoft 365 workbooks. The older Track Changes command belongs to the legacy Shared Workbook workflow in desktop Excel and is not the switch you need to use in the web app.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.