In Microsoft 365 Excel, save the workbook to OneDrive or SharePoint, then select Review > Show Changes to see supported cell edits, who made them, when, where, and the previous value. For earlier saved copies of the whole workbook, use File > Info > Version History.
What an Excel audit trail means
An audit trail is a record that helps explain how data changed over time. In Excel, people often use the phrase for two different features: Show Changes, which lists certain edits to cells, and Version History, which lists saved versions of the workbook. Neither is a complete record of every action a person might take in Excel.
That distinction matters in practice. If someone changes a tax-rate input from 7% to 8%, Show Changes may give you a useful cell-level entry with the prior value. If you need to inspect the workbook as it existed last Tuesday, Version History is the more relevant tool. A careful review may use both: find an edit in the changes pane, then compare saved versions if you need broader context.
Excel does not automatically turn every workbook into an immutable, compliance-grade audit log. A file saved only on a computer does not gain cloud change history simply because it is opened in Excel. The available record depends on where the file is stored, how people edit it, and which Excel features they use.
How to view cell changes with Show Changes
For a shared Microsoft 365 workbook, use these steps in Excel for Windows:
- Save the workbook in OneDrive or a SharePoint document library, and make sure the collaborators have access to that cloud file.
- Open the workbook in Excel and select Review > Show Changes.
- Read the Changes pane. Select an entry to inspect its sheet, cell or range, editor, time, and available before-and-after values.
- Use the pane’s filters, where available, to narrow the list by sheet, range, or person. Confirm the selected entry against the worksheet and any relevant source records.
Show Changes is intended for supported edits to cell values and formulas in collaborative workbooks. It can be useful for questions such as “Who replaced the forecast in D12?” or “What was in this cell before the latest edit?” Microsoft describes the pane as showing changes for up to 60 days. That is a limited lookback, not a permanent archive; do not assume an entry will remain available indefinitely.
Excel for the web also has Show Changes. In Excel for Mac, the feature is available in supported Microsoft 365 versions through Review > Show Changes, though the interface and feature availability can vary by update. If the command is missing, check that the workbook is cloud-stored, that you are signed in, and that Excel is up to date; opening the file in Excel for the web can help establish whether the workbook itself supports the feature.
Version History: a record of saved workbook states
Version History is different from the cell-by-cell Changes pane. It provides a list of earlier saved versions of a cloud-stored workbook. In Excel for Windows, open File > Info > Version History. Depending on the interface, you can open a version to inspect it or restore it. The version list and retention period depend on the cloud storage service and the organization’s settings.
Restoring an old version changes the current file to that earlier state, so do not treat Restore as a harmless preview. If you need to preserve the present workbook, first make a separate copy or download the relevant version where your permissions and interface allow it. A safer review is to open an older version for comparison without replacing the current working file.
Version History can help when you need to recover a formula, review a workbook before a major update, or determine whether a whole sheet disappeared. It is less convenient than Show Changes for identifying one particular cell edit. Conversely, Show Changes is not a substitute for retaining versions when you need a broader snapshot.
What Excel records—and what it may miss
Show Changes should be treated as a useful collaboration aid, not a complete playback of spreadsheet activity. It focuses on supported cell edits; it is not a guaranteed log of every formatting, layout, object, or structural operation. For example, a reviewer should not assume that changing a font color, moving a chart, hiding a sheet, or changing a workbook setting will appear as a clear cell-edit entry. The exact behavior can depend on the action and Excel version.
There are also practical reasons a record may be incomplete or hard to interpret:
- Lookback limits: the Show Changes pane covers a limited period, described by Microsoft as up to 60 days.
- Different editing routes: edits made with unsupported or older applications may not appear in the same way as edits made in current Excel.
- Large or complex operations: some actions affect many cells, making an entry less informative than a narrowly targeted edit.
- Shared identities: if people use the same sign-in, the displayed editor may not identify the actual person at the keyboard.
- Offline work or sync issues: an edit that has not synced may not yet be visible to other collaborators.
For an important discrepancy, verify the recorded change against source data, emails, approvals, or another system that documents the business process. A name and timestamp in Excel can help direct an investigation, but they do not by themselves prove why the change was made or whether it was authorized.
How to set up a more useful workbook history
Good recordkeeping starts before a problem occurs. Store the working file in an approved OneDrive or SharePoint location rather than passing around separate attachments named “final,” “final2,” and “final-revised.” Cloud storage supports collaboration and version history, while one shared source reduces confusion about which copy is authoritative.
- Give each person an individual account and assign only the access they need. This makes attribution more meaningful than a shared login.
- Use AutoSave and allow changes to sync before closing the file or handing work to someone else.
- Agree on which cells are inputs, who may edit them, and how a material change should be approved.
- Keep a separate, controlled record for decisions that require a reason, reviewer, approval date, or supporting document. A cell-change list usually does not capture that full context.
- For important milestones, retain a named copy or follow your organization’s document-retention process. Confirm that the method meets internal policy before relying on it.
For example, imagine a sales forecast where a manager changes the expected units in cell F14 from 1,200 to 1,500. Show Changes may help identify the editor, time, location, and previous value. It will not necessarily explain whether the increase came from a new customer order, an approved assumption, or a typing error. A change-request note linked to the relevant source can provide that missing rationale.
Protection, trust, and compliance limits
Worksheet protection and workbook passwords serve different purposes from an audit trail. Protect Sheet can restrict particular kinds of edits, such as changing locked cells, but it does not create a trustworthy history of who changed what. It is also not a substitute for access controls on the file. Use permissions in OneDrive or SharePoint to manage who can view or edit the workbook.
Show Changes and Version History are helpful evidence for ordinary collaboration and recovery, but they should not be described as tamper-proof records. Users with sufficient permissions may be able to edit, replace, or restore workbook content, and retention can be governed by settings outside the workbook. If a regulated process requires a permanent, independently controlled audit log, ask your organization’s compliance or IT team what approved records system to use. Do not rely on an Excel pane alone to satisfy a legal or regulatory requirement.
Legacy Track Changes and other options
Older Excel workflows include Track Changes (Legacy), associated with the legacy Shared Workbook feature. It is not the same as the current Show Changes pane, and it is not the recommended default for new collaborative workbooks. The legacy feature has limitations and can conflict with newer Excel capabilities. In Microsoft 365 for Windows, legacy commands may need to be added through File > Options > Customize Ribbon, choosing commands not currently on the ribbon. Organizations maintaining an older process should test it on a copy and check that it meets their compatibility needs before depending on it.
If Excel’s built-in history is not enough, alternatives depend on the need. A controlled SharePoint library can provide document versioning and access management; a database or dedicated workflow system may be better when changes need structured approvals, reasons, and searchable records. A manually maintained “change log” worksheet can record context, but it is easy to forget, alter, or delete, so it should not be treated as a secure audit system unless a separate process protects and reviews it.
Frequently Asked Questions
Can I see who changed a cell in Excel?
Yes, for supported edits in a cloud-stored collaborative workbook, open Review > Show Changes. The pane can show the editor, time, location, and prior value. It is not guaranteed to capture every kind of workbook action.
How far back does Excel Show Changes go?
Microsoft describes Show Changes as displaying changes for up to 60 days. For older workbook states, check Version History in OneDrive or SharePoint and remember that the available versions depend on retention settings.
Can I track changes in an Excel file saved on my computer?
A local-only file does not provide the same cloud-based Show Changes and Version History experience. Save it to OneDrive or SharePoint and use a supported Excel version for collaborative history, or use an approved external recordkeeping method.
Is Excel Version History the same as an audit log?
No. Version History lists saved states of a workbook, while Show Changes lists supported cell edits over a limited period. Neither necessarily records every action, explanation, or approval as an immutable audit event.
Can I recover an earlier version without losing the current one?
Make a separate copy of the current workbook before restoring an older version. Where available, open the historical version for inspection rather than restoring it over the current file.
Related
- Add Percentages to an Excel PivotTable
- Accounting Year-End Checklist Template for Excel Users
- 3-Way Forecast Excel Template: 3 Models to Compare
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Conditional Formatting Multiple Cells in Excel: RulesYes. In Excel for Microsoft 365, select the cells you want to format, then choose Home > Conditional…
- Google Docs Monthly Budget Template: Free Ways to StartYes, you can make a monthly budget for free with Google’s tools, but a budget with totals and…
- Using Solver in Excel to Maximize Profit Step by StepYes. In Excel for Microsoft 365 on Windows, use Solver to maximize a cell containing your profit formula…
- How to Import CSV to Excel: Steps and Common FixesTo import a CSV into Excel for Microsoft 365 on Windows, choose Data > Get Data > From…
- Hotel Laundry List Template Excel: Setup and UseA hotel laundry list template in Excel is a tracking sheet for recording laundry sent out, returned, missing,…
- Schedule an Email in Outlook: A Step-by-Step GuideTo schedule an outgoing email in Outlook, write your message, open the menu beside Send, choose Schedule send,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.