How do I stop different versions of the same file giving different answers?

Use one shared source and stop distributing editable copies. Lock the calculation rules, keep version history, and make reports pull from the same current data. If teams need different views, create those views from one source rather than creating separate files.