To check an audit trail in Excel for Microsoft 365, open the workbook and select Review > Show Changes to see supported edits, who made them, when they happened, and the earlier cell value. If the file is saved in OneDrive or SharePoint, also check File > Info > Version History to review or restore an earlier workbook version. These tools provide useful history, but they do not record every action or create a complete, tamper-proof audit log.
Before you start, confirm that you have access to the workbook and, if possible, that it is stored in OneDrive or SharePoint. For a shared file, use a current Microsoft 365 version of Excel and sign in with the account that has permission to open it. If you are reviewing a sensitive change, note the workbook name, the time period, and the cells or sheets you want to inspect. That makes the results easier to verify.
What You’ll Need
- The workbook: Open the file you want to review. Show Changes works best with a workbook saved in OneDrive or SharePoint and edited with a supported, current version of Excel.
- Permission to view the file: You need access to the workbook. To restore a prior version, you may also need permission to edit it.
- A clear review target: If you know the relevant worksheet, cell range, person, or approximate date, have that information ready. It narrows down what to look for.
- A backup before restoring: If you may replace the current workbook with an earlier version, save a separate copy first. Restoring a version changes the current file.
Step-by-Step
- Open the right workbook and confirm its location. In Excel for Windows, open the file and check that you are signed in to the Microsoft account or organization account that has access. A workbook stored in OneDrive or SharePoint is more likely to have usable coauthoring and version history than a file kept only on your computer. If necessary, use File > Info to inspect file details. A local copy may not contain the cloud-based history you need; opening a downloaded copy does not bring along the full history of the original cloud file.
- Open the Show Changes pane. Select the Review tab on the ribbon, then select Show Changes. Excel opens a pane listing supported changes. Each entry can include the person who made the change, the time, the affected cell, and the previous value. Select an entry to move to the relevant cell or inspect its details. If the button is unavailable, check that you are using a supported Microsoft 365 version and that the workbook is saved to OneDrive or SharePoint.
- Narrow the list to the part you are checking. Look through the pane for entries in the relevant sheet or cell range and for the time period you are investigating. Where the pane offers filters, use them to reduce the list by worksheet, range, or editor. The exact filtering options can vary with the Excel build. Select a change and compare its previous value with the current cell contents in the worksheet. For formulas, check the formula bar as well as the displayed result: two different formulas can produce the same visible number.
- Record what the history actually shows. For each relevant entry, note the worksheet, cell address, editor, timestamp, and old and new values if available. Keep the context with your notes, such as the workbook name and the time zone used by your account. Do not assume that a blank or missing entry proves nobody changed the data. Show Changes is a record of supported edits, not a record of every action taken in Excel.
- Check Version History for a broader snapshot. In the Windows desktop app, select File > Info > Version History. In some Microsoft 365 layouts, you can also select the workbook name in the title bar and choose Version History. Excel displays available saved versions with dates and, when available, the person who saved them. Select a version to open or inspect it. Version History is useful when you need to compare a workbook state from an earlier point, rather than inspect an individual cell edit.
- Compare an earlier version carefully. Open the earlier version without immediately replacing the current one. Depending on the interface, it may open separately or in a read-only view. Compare the relevant sheets and cells with the current workbook, and make notes or copy needed information into a separate file. Excel does not necessarily provide a detailed side-by-side comparison in the Version History list, so you may need to inspect the two versions separately. Avoid making changes in the historical view unless Excel clearly indicates that you are editing a separate copy.
- Restore only when that is the right fix. If the earlier version is the one you need, save a separate copy of the current workbook first. Then use the restore option in Version History and confirm the prompt. Reopen or refresh the workbook and verify the restored sheets and values. Restoring an earlier version replaces the current state with that snapshot; it is not the same as reverting just one cell. If you only need a few values, copying them into the current workbook may be safer than restoring the entire file.
Mac and web note: In Excel for Microsoft 365 on Mac, look for Review > Show Changes; the tab layout can differ slightly by build. Version history is available for files stored in OneDrive or SharePoint, though the exact route can vary between the desktop app and Excel for the web. In Excel for the web, check the Review tab for Show Changes, and use the workbook name or file information area to open version history. If a command is missing, update Excel or open the cloud file in a current browser version.
Common Mistakes
- Expecting a complete activity log. Show Changes is not a security-grade audit system. It focuses on supported cell edits; it does not reliably record every action, such as all formatting changes, worksheet operations, or workbook settings. A missing entry is not conclusive evidence that no change occurred.
- Checking the wrong copy. A file attached to an email, downloaded to the desktop, or saved under a different name may not be the original cloud workbook. Check the file location and open the shared OneDrive or SharePoint version when that is the file whose history matters.
- Confusing Version History with cell-level history. Version History shows saved workbook snapshots. It may help establish what the file looked like at a point in time, but it is not necessarily a complete list of individual edits or a detailed explanation of who changed every cell.
- Assuming the editor name identifies a person conclusively. The displayed name is associated with the account used to edit the workbook. Shared accounts, account-name changes, or edits made under another person’s sign-in can make attribution unclear. Confirm identity through your organization’s records when it matters.
- Restoring without saving the current state. A restore can replace newer work across the workbook. Save a copy first and confirm that the older version is genuinely the one you want before accepting the restore prompt.
- Relying on an old instruction for legacy Track Changes. Older Excel guides may describe Track Changes or Shared Workbook (Legacy). These are not the same as the current Show Changes pane, and legacy features have limitations. Do not assume they are enabled or available in your Microsoft 365 installation.
Tips
- Use both tools for different questions. Start with Show Changes to investigate specific cell edits. Use Version History to examine broader saved states or recover from an unwanted workbook-wide change.
- Check formulas, not just displayed values. Click a changed cell and inspect the formula bar. A result may look unchanged even though its formula, reference, or input has changed.
- Keep important workbooks in a managed cloud location. OneDrive and SharePoint support collaborative editing and version history, subject to the organization’s settings and retention policies. Saving there does not turn Excel into a formal compliance log, but it makes recovery and review more practical.
- Use meaningful filenames and notes. If you create a review copy, include the workbook name and review date in its filename. Keep a brief note about what you checked and which version you used, especially when more than one copy exists.
- Ask collaborators before drawing conclusions. If an entry is unexpected, confirm whether someone made a planned update, imported data, or edited through another client. The history can show what changed without explaining why.
- Set expectations for future reviews. If you need formal, long-term audit evidence, ask your Microsoft 365 administrator which retention, audit, or compliance tools are available for your organization. Excel’s change pane and workbook version list have limited scope and retention.
Troubleshooting
Show Changes is missing or greyed out: Confirm that the file is open in a current Microsoft 365 version of Excel and that you are signed in. Check whether the workbook is saved in OneDrive or SharePoint rather than only on a local drive or network location. Update Office if needed, then close and reopen the cloud file. If it is an older workbook format or is using a legacy shared-workbook feature, save a separate modern .xlsx copy and check whether the command becomes available. Do not overwrite the original just to test.
The change list is empty or seems incomplete: Verify that you opened the correct cloud file, not a downloaded duplicate. Check that the edits were made in a supported Excel client and within the available history period. Show Changes retains change details for a limited period—up to 60 days in supported Microsoft 365 experiences—and it does not capture every type of edit. Changes made using unsupported tools or actions may not appear. Use Version History as a separate check, but remember that it shows snapshots rather than a complete cell-by-cell log.
Version History is not available: Confirm that the workbook is stored in OneDrive or SharePoint and that you are signed in with an account that can access it. Your organization may restrict versioning or retention, or the file may be a local copy. Open the file from its cloud location and check again. If the option remains unavailable, ask the site or Microsoft 365 administrator whether version history is enabled and whether older versions have expired.
You cannot tell which of two versions is correct: Open each version separately and compare the relevant cells, formulas, and sheets. If the change affects important data, do not restore until you have preserved the current file and confirmed the intended values with the workbook owner. For large or complex workbooks, a dedicated comparison tool or administrator may be needed; the version list alone may not explain the differences.
A change appears under an unexpected name: Check whether a collaborator used a shared account, changed their profile name, or edited through a different organization account. Treat the displayed name as account information, not automatic proof of an individual’s identity. Ask the owner or administrator to check appropriate organizational records if reliable attribution is required.
Frequently Asked Questions
Does Excel have a built-in audit trail?
Excel has Show Changes and Version History for reviewing supported edits and saved versions, but neither is a complete, tamper-proof log of every workbook action. For formal audit requirements, check the compliance and audit tools managed by your organization.
Can I see who changed a particular cell?
Often, yes. Open Review > Show Changes, find the relevant entry, and select it to inspect the cell, editor, time, and previous value when those details are available. The result depends on the file, client, and type of edit.
How far back can I check changes?
Show Changes can display change details for up to 60 days in supported Microsoft 365 experiences. Version History may offer different dates depending on the storage service and your organization’s retention settings, so do not assume either history will be permanent.
Can I check an audit trail in an Excel file saved on my computer?
You can open and inspect a local workbook, but the current Show Changes and cloud Version History features rely on a supported cloud file and account setup. A local file may have no usable edit history. Check the original OneDrive or SharePoint file if it was shared online.
Can I recover one changed cell instead of restoring the whole workbook?
Version History restores a workbook version, so it can affect the entire file. For a single cell, use Show Changes to identify the prior value, then carefully enter or copy the correct value into the current workbook. Check formulas and references before replacing anything.
Does Show Changes track formatting, deleted sheets, and every workbook action?
No. It is designed to display supported changes, especially cell edits, and is not a complete record of formatting or workbook-level actions. Use Version History for broader snapshots, and consult your organization’s administrator if you need a more comprehensive record.
Related
- Capitalize in Excel: Shortcut Keys and Quick Methods
- How to Capitalize Text in Google Sheets Without Retyping
- Capitalize the First Word in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Alphabetize a Column: A Practical GuideTo alphabetize a column in Google Sheets, select a cell in your data and choose Data > Sort…
- Microsoft Excel Budget Tracking Template: How to Use ItYes—Microsoft Excel for Microsoft 365 offers budget templates you can open from File > New: search for “budget,”…
- Undo a Checkbox in Google Sheets: Uncheck or Remove ItTo undo a checkbox in Google Sheets, click a checked box to uncheck it; if you just changed…
- How to Autofit a Column in Excel to Fit Its ContentsTo AutoFit a column in Excel for Microsoft 365 on Windows, point to the right edge of its…
- How to Paste Backwards in Excel: Reverse Cell OrderTo paste a list backwards in Excel for Microsoft 365, enter =SORTBY(A2:A6,ROW(A2:A6),-1) in an empty cell, replacing A2:A6…
- Excel Dependent Dropdown List: Group Choices by CategoryYes. In Excel for Microsoft 365, make a group dropdown and a second dropdown that changes to show…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.