Linked data tables wont update automatically
 

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?

Linked data tables wont update automatically
 

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


"PaulH" wrote:

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?