To track edits in Excel for Microsoft 365, save the workbook to OneDrive or SharePoint, then select Review > Show Changes. The pane records who changed a cell, when it changed, where it is, and the previous value, for up to 60 days. For a longer record, use the file’s version history as well. Excel does not provide one permanent, tamper-proof audit log, so choose the tracking method that fits your needs.
What You’ll Need
- Excel for Microsoft 365 on Windows, with a workbook you can edit. The steps also apply to Excel for the web; current Excel for Mac builds may offer Show Changes on the Review tab.
- A workbook saved in OneDrive or SharePoint. Cloud storage is needed for the modern change history and version history; a file saved only on your computer will not provide the same record.
- Permission to edit the workbook and, if it is stored at work or school, access to the relevant OneDrive or SharePoint site. An administrator may control sharing or version-history settings.
- Optional: a separate test copy if you want to confirm the setup without adding trial edits to the working file.
Step-by-Step
- Save the workbook to a cloud location. In Excel for Windows, use File > Save As, choose OneDrive or a SharePoint location, and save the workbook. If the file is already there, confirm its location by checking the file name or using File > Info. A file attached to an email or stored in a local folder may not have the cloud features you need. If you do not have access to an appropriate cloud location, ask the file owner or your organization’s administrator.
- Confirm that the workbook is in a compatible format. A standard modern Excel workbook saved as an .xlsx file is suitable for most users. If Excel says the file is in Compatibility Mode or has an older .xls format, use File > Save As to create an .xlsx copy, provided that doing so will not break a required older workflow. Keep the original if you are unsure, especially if the workbook contains macros or depends on legacy features.
- Make sure you have editing access. Open the saved workbook and check that you can change a cell. If it opens as read-only, or Excel says you do not have permission, request edit access from the owner. Viewing access is not enough to make or track your own edits. For a team workbook, ask collaborators to open the same cloud-stored file rather than emailing separate copies; edits in separate copies will not form one shared change history.
- Open the change-history pane. Select the Review tab on the ribbon, then select Show Changes. Excel opens a pane listing recent edits. If the button is hidden by a narrow window, maximize Excel or look in the Review tab’s Changes area. On Excel for the web, open the workbook in the browser and look for Review > Show Changes. On a Mac, update Excel if the button is missing; its availability depends on the version and account. The modern option is not the same as the old Track Changes feature.
- Check what the pane records. Select an entry to inspect its worksheet, cell or range, editor, time, and previous value when that information is available. The entry helps you understand what was changed; it does not automatically explain why the person changed it. Review the actual cell and surrounding formulas or data before deciding whether an edit is correct. The pane can show changes made by you as well as changes made by collaborators.
- Use the pane to narrow your review. If the workbook has many edits, use the options available in the pane to focus on a particular worksheet, range, or editor. Select entries one by one when you need to inspect a specific change. The precise filters can vary by Excel build, so if a filter is not shown in your version, use the listed changes and inspect the relevant sheet directly. Do not assume that a filtered view deletes or alters the underlying workbook data.
- Turn on AutoSave and keep the file in the cloud. AutoSave is usually available near the upper-left corner for a workbook stored in OneDrive or SharePoint. Make sure it is on if you want edits to save as collaborators work. If your organization’s settings prevent AutoSave, use Ctrl+S on Windows or Command+S on Mac and check that Excel confirms the save. Saving supports collaboration and version history; it does not make the Show Changes pane a permanent audit archive.
- Use Version History for earlier snapshots. In Excel for Windows, go to File > Info > Version History, or select the workbook name and open Version History if that option appears there. Open an earlier version to inspect it. If you choose to restore one, first consider saving a copy of the current workbook: restoring changes which version is current and may replace later work. In Excel for the web or Mac, use the version-history option available from the file name or File menu. The exact controls can vary with the app and organization settings.
- Agree on a review routine with collaborators. Tell editors to work in the shared cloud file, not downloaded copies, and to identify important changes in a separate notes column or a team process when context matters. For a high-stakes workbook, assign someone to review changes and retain dated copies according to your organization’s policy. Show Changes is useful for reviewing edits, but it is not a substitute for access controls, backups, or a formal records system.
Optional legacy method: Some teams still need the older Track Changes feature for compatibility with an established shared-workbook process. In Excel for Windows, add the legacy commands through File > Options > Quick Access Toolbar; set Choose commands from to All Commands, then add Share Workbook (Legacy) and Track Changes (Legacy). Use the legacy sharing command to configure the workbook, then use Track Changes (Legacy) to set its highlighting options. This feature has significant limitations and can disable or restrict newer Excel capabilities. It is not the recommended way to start tracking a new Microsoft 365 workbook. Mac menus and availability differ, and Excel for the web does not provide this Windows legacy setup.
Common Mistakes
- Expecting a full permanent log from Show Changes. Its change list covers up to 60 days, not an unlimited period. Use Version History and an organization-approved retention process when you need records beyond that window.
- Keeping the only copy on a computer or emailing copies around. Local files and disconnected copies do not provide one shared cloud history. Move the working file to OneDrive or SharePoint and have editors use that file.
- Confusing protection with auditing. Protecting a sheet or workbook can limit editing, but it does not create a detailed record of who changed each cell. Set permissions for control and use change history for review.
- Assuming every action appears as a normal cell edit. Some operations, such as changes made by certain tools, macros, or external processes, may not appear in the same way as direct cell edits. Verify important results against the workbook and do not treat the pane as a complete record of every action.
- Restoring a version without preserving current work. A restore can replace the current version. Save a separate copy first if you may need to return to the present state.
Tips
- Give the shared workbook a clear name and store it in a team folder with sensible permissions. This helps collaborators find the correct file and reduces parallel copies.
- Use a test copy to learn where Show Changes appears and how entries are displayed. Avoid making sample edits in a live financial, operational, or reporting workbook.
- Record the reason for consequential edits in an adjacent notes or comments workflow. A previous value and editor name can show what happened, but may not capture the business reason or approval.
- Schedule periodic reviews if the workbook matters. The 60-day change list is time-limited, and version-history availability can depend on the storage service and administrator settings.
- For important records, follow your organization’s retention and compliance requirements. A normal Excel workbook can be edited by people with sufficient access, so it should not be treated as an immutable audit system.
Troubleshooting
Show Changes is missing or unavailable: Confirm that you are signed in to the Microsoft 365 account that has access to the workbook, and that you have opened the file in a supported, up-to-date Excel app. Save it to OneDrive or SharePoint, then reopen it and check Review. If the command is still absent, try Excel for the web or ask your Microsoft 365 administrator whether your account, app version, or organization policy limits the feature. Do not add the legacy Track Changes command as a quick fix unless you specifically need the old shared-workbook workflow.
The pane shows no edits: Check that you are viewing the right cloud file, not a downloaded copy or another workbook with the same name. Make a small, harmless edit in a test copy, save it, and reopen Show Changes. Recent changes may take time to sync. Changes older than 60 days may no longer appear there, and edits performed through unsupported workflows may not be listed as expected.
You cannot edit or save: Check whether the workbook is read-only, whether you are signed in with the right account, and whether the owner granted edit permission. If AutoSave is off or Excel reports a sync problem, reconnect to the internet, resolve any conflict prompts, and save again. Avoid making further edits in a second copy until you know which file is the team’s source of truth.
Version History is missing: Verify that the file is stored in OneDrive or SharePoint and that you have permission to view its history. A local file will not have the cloud service’s version history. If the workbook is cloud-stored but the option is absent, the organization may have a policy or configuration affecting it; contact the site owner or administrator. Keep a separate dated copy before making major changes if you cannot confirm that version history is available.
An edit is not shown or looks unexpected: Refresh or reopen the workbook after it finishes syncing, then check the correct sheet and cell. Compare the current value with an earlier version if available. If a formula, macro, import, or other automated process was involved, validate its output separately and ask the process owner what it changed. Do not rely on an empty change list as proof that no changes occurred.
Frequently Asked Questions
Does Excel have a built-in audit trail?
Excel has change-review and version-history features, but they are not a single, permanent, tamper-proof audit log. Show Changes lists recent cell edits in supported cloud workbooks; Version History provides saved snapshots. Use a formal records or audit system when your requirements demand an immutable record.
How long does Show Changes keep edits?
The Show Changes pane displays changes for up to 60 days. It is not a long-term archive. Version History may let you review earlier saved versions, but how many are available and how long they remain can depend on OneDrive or SharePoint settings and your organization’s retention policies.
Can I track changes in an Excel file saved only on my computer?
Not with the modern cloud-based Show Changes and Version History workflow described here. Save the workbook to OneDrive or SharePoint and open that shared file. You can keep local backups, but separate local copies do not create a combined history of collaborators’ edits.
Can I see who changed a cell and what it was before?
Show Changes can display the editor, time, location, and previous value for a listed edit. The details available can vary with the change and Excel version. It does not necessarily explain why the change was made, and it should not be assumed to capture every kind of workbook action.
Is Track Changes (Legacy) the same as Show Changes?
No. Show Changes is the modern review pane for supported Microsoft 365 cloud workbooks. Track Changes (Legacy) belongs to Excel’s older shared-workbook feature and has different limits. Choose the modern option for a new shared workbook unless compatibility with a legacy process requires otherwise.
Can I turn off the audit trail after enabling it?
Show Changes is a review pane, not a switch that creates a complete logging system. You can close the pane, but that does not erase the workbook’s cloud version history. Storage administrators may manage retention settings; closing the pane should not be treated as deleting records.
Related
- How to Delete Multiple Worksheets in Excel
- How to Delete One Cell in Excel and Shift Nearby Data
- How to Delete Microsoft Excel Without Losing Files
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Insert a Line in Word Without Text: Simple MethodsTo insert a horizontal line in Word without typing text, place the cursor in an empty paragraph and…
- Excel Cell Merge Shortcut Keys and How to Use ThemIn Excel for Microsoft 365 on Windows, select the cells and press Alt+H, M, then C to use…
- How to Insert an Image in Excel (Step-by-Step)To insert an image in Excel for Microsoft 365 on Windows, select the worksheet, choose Insert > Pictures…
- Where to Insert a Table of Contents in WordIn Word, insert a table of contents (TOC) where you want it to appear—usually near the beginning of…
- Excel Continually Not Responding? Causes and FixesIf Excel continually says “Not Responding,” first give it a few minutes if it may be calculating, saving,…
- Excel Days, Hours, and Minutes: Format DurationsTo show an elapsed time in Excel as days, hours, and minutes, keep the duration as a number…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.