Two workbook copies display the same total. One has a calculation and one has the number pasted in. Compare formula counts first, then inspect the specific cells that should still calculate.

Use a source with a known count

In Ulet Sheets, open Review → Workbook Statistics in the source and the delivery copy. The sample source has two sheets and seven formulas. The delivery copy has two sheets and six formulas. Record which cells you expected to stay live.

An example statistics comparison shows two sheets in both files but seven formulas in the source and six in the delivery copy.

Illustrated workbook comparison. A count change identifies something to inspect.

Inspect the suspect total in both files

Select the total and read its formula bar. In the example the source has =SUM(B2:B5) and the delivery copy stores 42. Restore the calculation if the delivery is meant to be editable, then change a test input in a copy and check that the total responds.

The source formula bar shows =SUM(B2:B5) while the delivery copy stores 42.

Illustrated cell-level proof. The same displayed total can come from different contents.

If Statistics reports a loaded region only, treat the count as partial. Even equal counts leave the actual formulas to inspect.