If I have a workbook (#1) that includes a cell linked to another workbook (#2) that, in turn, is linked to a third workbook (#3). If I change the linked cell in #3, then I open #1 and recalculate, will it pick up the change or do I need to open #2 and recalc before #1 has the right answer? It seems that #2 would always need to be opened and recalculated for #1 to be right. Correct?

Thanks,
RR