Thanks for the tip but F9 did not do anything.

"Dave O" wrote:

I've seen this, too, and found that I have to press F9 to recalculate
the spreadsheet.