Seven checks before you sign off an Excel™ calculation
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
- A number typed inside a formula, such as
=B10*0.2. It may be deliberate, but it should be a labelled input. - A typed value where the cells above and below calculate. A likely overtype.
- Error values such as
#REF!anywhere in the calculation. - A reference to another workbook. The result then depends on a file that is not part of the sign-off.
- Calculation cells left unprotected.
- A formula inside an input range, which means a person is expected to type over a calculation.
- 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.
- Press Ctrl+` to show formulas. Scan for typed numbers and for a number standing in a column of formulas.
- Press F5, choose Special, and tick Formulas → Errors to select error cells.
- Open Data → Edit Links to find other workbooks.
- Check Review → Protect Sheet status, and which cells are unlocked under Format Cells → Protection.
- 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.