| 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? |
| 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 | |||
Threaded Mode
