AppGarden Calculation Sign-Off and Lock logo AppGarden

Calculation Sign-Off and Lock

How to show an Excel™ calculation has not changed since it was checked

By Paul Kemp · Published

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

By hand

These steps apply to Excel™ in Microsoft 365. Work on a copy.

  1. Designate your input cells and shade them consistently.
  2. Add a sign-off block on a separate sheet: name, role, date, revision, comment.
  3. 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.
  4. To verify later, put the old formulas next to the new with =FORMULATEXT(...) and compare.
  5. 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.