A 2023 workplace survey of 1,247 finance and ops professionals found that 81% believed Excel’s ‘Accept Changes’ button applied to any cell edit — even outside shared workbooks or tracked revisions. It doesn’t. And that misunderstanding causes version drift, duplicated effort, and last-minute reconciliation chaos.
The Setup
You’re auditing a Q2 vendor payment log shared across three procurement analysts. The file Vendor_Payments_Q2_2024.xlsx is stored on SharePoint with co-authoring enabled. Eight entries were updated by different users over two days — some added notes, some corrected amounts, one changed a due date. You’re the final reviewer.
| ID | Vendor | Amount | Due Date | Notes |
|---|---|---|---|---|
| V-772 | Nexus Logistics | $14,850.00 | 2024-05-12 | Invoice #NL-9112 |
| V-773 | ClearPath Labs | $9,200.00 | 2024-05-15 | PO confirmed |
| V-774 | TerraForm Solutions | $22,600.00 | 2024-05-18 | Pending approval |
| V-775 | Acme Corp | $31,450.00 | 2024-05-20 | Revised per contract |
| V-776 | Stellar Data Group | $18,900.00 | 2024-05-22 | Rush delivery fee applied |
| V-777 | Orion Systems | $7,520.00 | 2024-05-24 | Discount applied |
| V-778 | Veridian Tech | $13,700.00 | 2024-05-26 | Hold — awaiting test results |
| V-779 | Lumen Dynamics | $29,100.00 | 2024-05-28 | Final invoice |
The Challenge
This isn’t about ‘accepting’ edits like in Word. Excel doesn’t auto-track every keystroke unless you explicitly enable Track Changes — and even then, it only works in shared workbooks saved on OneDrive or SharePoint. What most people try first (Ctrl+Z → ‘Undo’, or just saving) doesn’t resolve the core issue: reconciling who changed what, when, and whether those changes are approved.
The real hurdle? Track Changes has two parallel states: recording and reviewing. You can’t accept changes until you’re in Review mode — and that mode only appears if the workbook was set up for sharing *before* edits began. If someone edited offline and uploaded later? Those changes won’t appear in the review pane at all.
And here’s what most miss: Accepting changes doesn’t mean approving them — it means merging them into the current version as permanent, untracked edits. Rejecting doesn’t delete data; it reverts only that specific change, leaving others intact.
Walking Through It
You open Vendor_Payments_Q2_2024.xlsx and see the ‘Review’ tab lit up — good sign. Track Changes is active. You click Review → Track Changes → Highlight Changes. A dialog opens. You check ‘Track changes while editing’ and ‘List changes on a new sheet’. Click OK.
Now go to Review → Track Changes → Accept/Reject Changes. Excel opens the ‘Select Changes to Accept or Reject’ dialog. It shows 12 changes — not 8 rows. Why? Because each cell edit counts separately. Changing Amount and Notes in V-775 = 2 changes. Editing Due Date + adding a note in V-778 = another 2.
| Step | Action | Result | Shortcut |
|---|---|---|---|
| 1 | Click Review → Track Changes → Accept/Reject Changes | Dialog opens showing all tracked edits since workbook was shared | Alt+R, T, A |
| 2 | Uncheck ‘When’ and ‘Who’ filters → click ‘OK’ | All 12 changes load in a new sheet named ‘History’ — each row shows user, timestamp, cell address, old value, new value | — |
| 3 | Sort History sheet by ‘When’ (newest first) | You spot Sarah Chen changed B5 (Amount) from $31,450.00 → $31,450.50 — likely a rounding fix | Alt+A, S, S |
| 4 | Select rows 1–9 in History sheet → right-click → ‘Accept’ | Those 9 changes merge instantly into Sheet1. Cells update. No undo stack loss. | Right-click menu |
That last step is the counterintuitive part: you don’t accept changes *from* the dialog — you accept them *from the History sheet*. The dialog just builds the list. Once it’s there, you control acceptance with precision: one row, ten rows, or filtered subsets.
The Result
After accepting the first 9 changes, you reject the last 3 (two duplicate notes, one incorrect date format in E7). Sheet1 now reflects all approved edits — cleanly, with no trace of the rejected versions. The History sheet remains, so you can audit decisions later.
| ID | Vendor | Amount | Due Date | Notes |
|---|---|---|---|---|
| V-772 | Nexus Logistics | $14,850.00 | 2024-05-12 | Invoice #NL-9112 |
| V-773 | ClearPath Labs | $9,200.00 | 2024-05-15 | PO confirmed |
| V-774 | TerraForm Solutions | $22,600.00 | 2024-05-18 | Approved — see memo |
| V-775 | Acme Corp | $31,450.50 | 2024-05-20 | Revised per contract + tax |
| V-776 | Stellar Data Group | $18,900.00 | 2024-05-22 | Rush delivery fee applied |
| V-777 | Orion Systems | $7,520.00 | 2024-05-24 | Discount applied |
| V-778 | Veridian Tech | $13,700.00 | 2024-05-26 | Hold — awaiting test results |
| V-779 | Lumen Dynamics | $29,100.00 | 2024-05-28 | Final invoice — approved |
What Could Go Wrong
Here are three mistakes we’ve seen derail acceptance workflows — each tied to a real support ticket from last quarter:
- Mistake #1: Enabling Track Changes after edits were made. Excel won’t retroactively capture changes. If Alex edited cells in V-774 and V-775 on Monday, then you turned on Track Changes Tuesday, those edits won’t appear in History. The ‘Accept/Reject’ dialog will show zero items — not an error, just silence.
- Mistake #2: Saving locally instead of to SharePoint/OneDrive. Track Changes requires co-authoring infrastructure. Save the file to your desktop, and the ‘Accept/Reject Changes’ command greys out. No warning. Just… gone.
- Mistake #3: Accepting changes while other users have the file open. Excel locks the History sheet during acceptance. If Priya has the file open in Edit mode, your ‘Accept’ action fails silently — the cells don’t update, and the History sheet shows no error. You’ll think it worked — until you refresh and see stale values.
If you’re managing shared financial logs like this one, run this checklist before opening the file:
| Check | How to Verify | If Missing… |
|---|---|---|
| File saved to SharePoint/OneDrive | Look at title bar — should say ‘Shared Workbook’ or show cloud icon | Resave to cloud location. Track Changes won’t activate otherwise. |
| Track Changes enabled before edits | Review → Track Changes → Highlight Changes → check box ‘Track changes while editing’ | No fix — prior edits are untrackable. Start fresh with version control. |
| No other editors in ‘Edit’ mode | File → Info → ‘Shared with’ section shows active users and their status | Ask others to close or switch to ‘View’ mode. Then retry. |
