Begs the question why Gnumeric didn't automatically recalc the file
when it opened.

Because...

(a) it isn't supposed to matter.
(b) doing so would change values:
(b1) Missing functions.
(b2) Randon numbers.
(b3) Circular dependencies.

M.