Find the Audit Trail in Excel: Changes and History

How-to basics · Updated November 20, 2026

To find recent cell edits in Excel for Microsoft 365 on Windows, open the workbook and select Review > Show Changes. For older saved copies, use File > Info > Version History. These tools can show who changed a cell and when, or help you inspect an earlier workbook version, but Excel does not provide one complete, permanent audit log of every action.

For the most useful record, keep the workbook on OneDrive or SharePoint and have collaborators edit that shared file while signed in. Show Changes generally covers the last 60 days; Version History stores earlier saved copies according to the file’s storage and retention settings. If you need a formal, tamper-resistant compliance record, Excel’s built-in history may not be sufficient.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or Excel for the web. The Review tab and some labels may look different in other releases.
  • The workbook itself. To use Version History, it must be saved in OneDrive or SharePoint; a file stored only on your computer has no cloud version history.
  • For edits made by other people, access to the shared workbook and, where necessary, permission to view its history.
  • The approximate sheet, cell, editor, or date you want to investigate. A narrow search makes a busy change list easier to interpret.

Step-by-Step

  1. Open the right copy of the workbook. Start Excel and open the file from its OneDrive or SharePoint location, not a downloaded attachment or an older copy in your Documents folder. Check the workbook name and, if shown, its save or cloud status. If coworkers have been editing a different copy, the history in the file you opened will not include their work. If the file is local, you can still inspect available information, but you may not have cloud version history or a shared edit record.
  2. Open the recent edit list. Select the Review tab on the ribbon, then select Show Changes. Excel opens a pane listing changes it can report, typically with the editor’s name, the time, the affected location, and the previous value. If the button is not immediately visible, widen the Excel window or inspect the Review tab’s controls; ribbon layouts can vary with window size and updates. Excel for the web also has Show Changes on the Review tab.
  3. Find the relevant edit in the pane. Read the entries and look for the sheet and cell address, such as Sales!B14, as well as the editor and timestamp. Select an entry to navigate to the affected cell and see the details Excel has available. If there are many entries, use the pane’s available filters, such as filtering by sheet or range, and narrow the search to the relevant area. A timestamp is shown in the context of the workbook’s activity; confirm the date and time zone if coordinating with someone in another region.
  4. Check the previous and current values. Compare the value recorded as the earlier value with what is now in the cell. Also look at the formula bar: a change from a typed number to a formula, for example, can be important even if both cells display the same result. Select the cell and review the surrounding rows and columns before concluding that an edit was incorrect. The change list is evidence of a reported cell edit, not an explanation of why the person made it.
  5. Look for an older saved version if the edit is outside the recent window. In Excel for Windows, select File > Info > Version History. Depending on the Excel build, you can also select the workbook name in the title bar and choose Version History. A pane lists available saved versions and their dates. Open a candidate version to inspect it. Version history is available for files stored on OneDrive or SharePoint, but the number and age of copies depend on the service and retention settings.
  6. Compare carefully before restoring anything. A version is a saved snapshot, not necessarily a detailed list of every cell edit between two moments. Check its date and contents against the current workbook. If you want to restore an earlier version, first save a separate copy of the current workbook or make sure its latest changes are safe. Then use the restore option shown for that version. Restoring replaces the current file state with the selected earlier state; it is not the same as copying one old cell value.
  7. Record what you found outside the cell if needed. For a review, note the workbook name, sheet and cell, editor shown, timestamp, previous value, current value, and the version you consulted. Follow your organization’s approved process for retaining evidence. Do not assume the Show Changes pane is a permanent archive: its recent edit history is limited, and later file changes or storage policies can affect what remains available.
  8. Set up a better record for future work. Store the workbook in the team’s designated OneDrive or SharePoint location, share that file rather than circulating email attachments, and ask editors to use their individual accounts. Agree on who may edit sensitive ranges and how often important versions should be preserved. If you require a formal audit trail, ask your Microsoft 365 administrator or compliance team about an approved logging or records system rather than relying on a spreadsheet alone.

Mac note: Excel for Mac also supports Show Changes in Microsoft 365, though the ribbon arrangement can differ. For a cloud file, use the version-history option available from the workbook or File menu; its label and placement can vary by release. Excel for the web is a practical alternative when a desktop ribbon does not show the control, provided you have access to the shared file.

Common Mistakes

  • Expecting a full record of every action. Show Changes is primarily for reviewing supported cell-level edits, not a comprehensive log of every view, formatting adjustment, object change, or administrative event. Some kinds of workbook changes may not appear as ordinary cell entries. Treat an empty list as “no reportable changes shown,” not proof that nothing happened.
  • Confusing Show Changes with Version History. Show Changes gives details about recent reported edits. Version History gives saved snapshots that can be opened or restored. One does not automatically provide all the information of the other.
  • Looking at a local or stale copy. A file downloaded from email may be detached from the shared cloud workbook. Its history can stop at the point it was downloaded, even if the team continued editing the online file.
  • Assuming the 60-day period is unlimited retention. Show Changes reports recent activity, generally for up to 60 days. It is not a permanent audit archive, and older edits may no longer appear there.
  • Restoring a version before protecting current work. A restore can replace newer content. Save a copy of the current workbook first, and confirm that you are restoring the intended file and version.
  • Sharing one account among editors. If several people edit while signed in as the same account, the editor attribution cannot reliably distinguish them. Individual sign-ins make the displayed names more useful.

Tips

  • Search using a known cell address or a small range before reviewing a large sheet. Include the sheet name because the same cell address can exist on multiple sheets.
  • When a number looks suspicious, inspect the formula bar and relevant dependent cells. A displayed result alone may hide a formula change or a change in a referenced input.
  • Keep a clean naming and storage practice. Store one authoritative shared workbook in the team location and link to it instead of making multiple similarly named copies.
  • Before a high-impact review or bulk update, make a clearly dated backup copy if your organization permits it. A deliberate checkpoint can make later investigation easier, but it does not replace access controls or formal logging.
  • For a shared investigation, capture the details you are allowed to retain: file path, version date, cell address, and the values involved. Avoid sending sensitive workbook contents to people who do not have permission to see them.
  • When the issue concerns who had access, when a file was shared, or other account-level activity, ask the Microsoft 365 administrator. Those questions may require service or organization audit records, not Excel’s cell-change pane.

Troubleshooting

  • Show Changes is missing or disabled: Confirm that you opened the intended workbook in a supported, up-to-date Microsoft 365 version and that the Review tab is visible. Try Excel for the web. If the file is read-only, protected, or opened from an unsupported location, save or open the authorized shared copy and check your access. Some older perpetual Excel releases do not have the same current coauthoring controls.
  • The pane is empty: Verify the file location and confirm that the edits were made in this exact workbook. Check whether the activity is older than the recent history window or came from an operation that Show Changes does not report. Compare available cloud versions, and ask the editor or administrator if the activity matters.
  • You cannot find a coworker’s name: Make sure the person edited the shared file while signed in to their own account. A local copy, an offline edit that has not synced, or a shared sign-in can prevent useful attribution. Allow syncing to finish, reopen the cloud workbook, and check again.
  • Version History is not available: Confirm that the workbook is saved on OneDrive or SharePoint and that you have permission to access it. A file kept only on a local drive will not have cloud versions. If it is a cloud file but the option is absent, check with the file owner or Microsoft 365 administrator about permissions, account, and retention.
  • The old version does not show the exact edit: Version History contains snapshots, so a version from before and one after an edit may not identify every intermediate action. Open the closest available versions and compare the relevant cells manually. If precise audit evidence is required, use an approved logging process going forward.
  • You restored the wrong version: Do not continue editing until you understand what changed. Check Version History for the state that was current before restoration and recover needed work from that copy if available. If recovery is unclear, contact the file owner or administrator before overwriting more content.

Frequently Asked Questions

Does Excel have an audit trail?
Excel has Show Changes for recent supported edits and Version History for saved cloud-file snapshots. Neither is a universal, permanent log of every workbook action.

How far back can I see cell changes?
Show Changes generally displays activity from the last 60 days. For older points in time, check Version History if the file is stored on OneDrive or SharePoint and versions are still retained.

Can I see who changed a cell?
Show Changes can identify the editor for supported edits when people use their own accounts in the shared workbook. Shared accounts and disconnected copies make attribution less reliable.

Can I see who viewed or opened an Excel file?
Show Changes is for reported workbook edits, not a reader or file-open log. Ask your Microsoft 365 administrator whether organization-level audit records are available for your account and situation.

Can I recover a deleted value?
Check Show Changes for a recent reported edit, or open a suitable earlier version from Version History and copy the value. Save the current workbook before restoring a full version so newer work is not lost.

Can I use this as a compliance audit record?
Do not assume so. Excel’s built-in features have limits on scope and retention. Ask your organization’s compliance or Microsoft 365 administrator to identify an approved system that meets its recordkeeping requirements.

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.