Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get the data in a chart to automatically update? | Charts and Charting in Excel | |||
Opening Protected EXCEL worksheets to update linked data | Excel Discussion (Misc queries) | |||
Opening Protected EXCEL worksheets to update linked data | Setting up and Configuration of Excel | |||
Opening Protected EXCEL worksheets to update linked data | Links and Linking in Excel | |||
Format a chart to automatically update with last 26 data points? | Charts and Charting in Excel |