How to show an Excel™ calculation has not changed since it was checked
A calculation is checked on Tuesday. On Friday someone asks whether it is still the one that was checked. Excel™ has no built-in way to answer that, and a locked sheet is not an answer, because protection can be removed in seconds.
What a sign-off should capture
- Who checked it, and in what role (prepared, checked, approved).
- When, and which revision.
- What exactly was checked: the formulas, the constants outside the input cells, the defined names and the sheets.
- Which cells are inputs, so that changing an input is not mistaken for changing the calculation.
By hand
These steps apply to Excel™ in Microsoft 365. Work on a copy.
- Designate your input cells and shade them consistently.
- Add a sign-off block on a separate sheet: name, role, date, revision, comment.
- Press Ctrl+` and save a copy of the formulas, for example with Formulas → Show Formulas and a print to PDF, kept with the sign-off.
- To verify later, put the old formulas next to the new with
=FORMULATEXT(...)and compare. - Record changes to inputs separately from changes to logic.
This works, but it relies on discipline and does not detect a change nobody thought to check.
What a record cannot prove
A signed record shows the logic is unchanged since it was signed. It does not show the logic was right. Sheet protection is tamper evidence, not prevention. A typed name is not a verified identity. A tool like this is not an electronic-signature system for regulated records.
Sign and verify in the workbook
Calculation Sign-Off and Lock stores a fingerprint of the calculation's logic inside the workbook, and Verify then shows green, red or amber. Green means the logic is unchanged; red lists each changed cell with its content now and at signing; amber is never a pass. Verify is free for anyone, with no key, no account and no network request. Signing a few records a month is free too.
See Calculation Sign-Off and Lock for Excel™
Microsoft, Excel and Microsoft 365 are trademarks of the Microsoft group of companies. Calculation Sign-Off and Lock is made by App Garden and is not affiliated with or endorsed by Microsoft.