Linked data tables won’t update automatically

[PaulH]

I have a data table that depends upon the values in another data table. With
the recalculation option set to Automatic, I need to do a manual recalc
whenever the first table changes, in order to update the second table. With
recalc set to Automatic Except Tables, I need to do 2 manual recalcs to
update the second table (and 3, if I link a third table to the second table).
Apparently, Excel calculates all tables using current values before updating
any of them. Is there any way to get all tables to update automatically?

 

[PaulH]

Some progress. I see that a single Full Calculate (Ctrl-Alt-F9) does the
trick. Is there a way to tell Excel to always do Full Calculations, either
automatically, or when a user hits F9? Preferrably both, since I think this
workbook is going to be too slow to leave recalculation set to Automatic.

Thanks