AppGarden Calculation Sign-Off and Lock logo AppGarden

Calculation Sign-Off and Lock

Seven checks before you sign off an Excel™ calculation

By Paul Kemp · Published

Signing off a calculation means saying "this is the one I checked". Before you say it, make sure there is nothing in it that makes the statement shaky.

The seven checks

  1. A number typed inside a formula, such as =B10*0.2. It may be deliberate, but it should be a labelled input.
  2. A typed value where the cells above and below calculate. A likely overtype.
  3. Error values such as #REF! anywhere in the calculation.
  4. A reference to another workbook. The result then depends on a file that is not part of the sign-off.
  5. Calculation cells left unprotected.
  6. A formula inside an input range, which means a person is expected to type over a calculation.
  7. No input cells designated, so there is no way to separate inputs from logic.

Check by hand

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

  1. Press Ctrl+` to show formulas. Scan for typed numbers and for a number standing in a column of formulas.
  2. Press F5, choose Special, and tick Formulas → Errors to select error cells.
  3. Open Data → Edit Links to find other workbooks.
  4. Check Review → Protect Sheet status, and which cells are unlocked under Format Cells → Protection.
  5. List your input cells in a note, so anyone can see what is meant to change.

Run the same list in the pane

Calculation Sign-Off and Lock's pre-sign checks cover these seven points (CS-01 to CS-07) and mark each as advisory or a blocker. They do not stop you signing: the judgement is yours. Pre-sign checks are a paid feature, while Verify, which compares a workbook with its signed record, is free for anyone. The add-in does not judge whether a calculation is right, and it is not an electronic-signature system for regulated records.

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.