Duke Carey wrote...
Off the top of my head I can't think of any way that Excel would
know the underlying data has changed. . . .
....

If the underlying data is in a worksheet range, any changes would
trigger recalculation. Figure it out from there.