Excel version history

Version history shows the file changed — not what changed

OneDrive and SharePoint can roll a workbook back to last Tuesday. They can’t tell you which formula moved, who moved it, or which cells were affected. SheetDelta adds exactly that — without moving off SharePoint.

See the platform Compare two files now

What Excel version history actually does

When your workbook lives in OneDrive or SharePoint, Microsoft keeps a list of saved versions. Open the file’s Version History and you can view or restore any of them; with AutoSave on, new versions are written as people work. It’s genuinely useful as a safety net — if a workbook gets mangled, you can roll the whole thing back.

The catch is in the word versions. It stores snapshots of the file. It never compares them. So the one question you actually have — what changed between this version and the last one? — is the one it can’t answer.

Where version history leaves you stuck

It versions the file, not the changes

You can restore the whole workbook to an earlier point. You can’t see which formula moved, which cells changed, or what a single edit did. The change itself is invisible.

No who-changed-what at the cell level

SharePoint records who saved each version, but not who touched a given cell or why. When a number is suddenly wrong, “last modified by” doesn’t tell you who broke it.

Silent overwrites and version sprawl

AutoSave keeps writing versions; a careless paste can quietly overwrite a formula with a value, and nobody notices until it matters. You end up scrolling a list of timestamps, opening each to guess what’s different.

It stops at the cloud boundary

Email a copy to a client or a colleague outside the tenant and the version history doesn’t follow. The thread comes back as Budget_v3_FINAL_final.xlsx, and you’re comparing by hand again.

“It versions the entire file, but not the actual changes inside it. So if something goes wrong you can roll back the whole workbook, but you still have no idea what changed, who changed it, which cells or formulas were affected.” — a finance analyst, describing the exact gap, on r/excel

The comparison layer SharePoint is missing

	SharePoint / OneDrive version history	SheetDelta
Restore an earlier version of the file
See which cells & formulas changed	—
See who changed a specific value	File-level only
Compare any two versions side by side	—
Review & sign off on a change	—
Flag formula-to-value overwrites	—
Exportable audit trail	—
Works on files emailed outside the tenant	—

Keep SharePoint. Add the comparison.

SheetDelta watches the library your team already saves to. Each new version is compared against the one before it automatically, so you get a readable history of changes alongside SharePoint’s history of files: which cell, which formula, who, and when — plus the option to comment, review, and sign off before a change is trusted.

Nobody changes how they work. The version history you already rely on stays exactly where it is. SheetDelta just answers the question it was never able to.

Frequently asked questions

How do I see version history for an Excel file?

For files in OneDrive or SharePoint: open the file, click the title bar (or right-click the file in the web view) and choose Version History. You’ll get a list of saved versions you can open or restore. It’s a real backup — it just won’t tell you what changed between any two of them.

Does Excel version history show which cells changed?

No. It restores whole versions; it does not compare them. To see the actual cell, formula, and structural changes between two versions, you need a comparison layer like SheetDelta on top of the versions you already keep.

How far back does version history go?

It depends on your SharePoint/OneDrive retention settings — often dozens of versions or more. SheetDelta keeps a parallel, comparable history with retention you control, so you’re not at the mercy of a setting an admin changed.

Do I have to move off SharePoint to use SheetDelta?

No. SheetDelta watches the same SharePoint or OneDrive library you already use. Keep saving exactly where you save today — SheetDelta just adds the “what changed, who changed it, is it approved” layer on top.