Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
nested links
Hi
I have a worksheet that is linked to 4 different worksheets, each of them contains links to another 10 worksheets which contains links to other worksheets. There are no circular reference amongst them but there are 4 levels of links at the moment. Each time when I opened the master worksheet, the links are not automatically updated to reflect the present data on the lowest level worksheets (I guess Excel could only update the links at one level). Is there a way to make the links at the master worksheet up to date without opening the other worksheets? Thanks. Mike |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
nested links
I think you'll actually need to open the lower level files - XL
retrieves the stored values in closed files, it doesn't evaluate whether those values are the result of a calculation or external reference. In article , "mike" wrote: Hi I have a worksheet that is linked to 4 different worksheets, each of them contains links to another 10 worksheets which contains links to other worksheets. There are no circular reference amongst them but there are 4 levels of links at the moment. Each time when I opened the master worksheet, the links are not automatically updated to reflect the present data on the lowest level worksheets (I guess Excel could only update the links at one level). Is there a way to make the links at the master worksheet up to date without opening the other worksheets? Thanks. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |