I have a hierarchy of 4 excel spreadsheets that link to one another. WKSHT 1
is the original information that gets changed manually, WKSHT 2 gets its
information and is updated by linking to information in WKSHT 1, WKSHT 3
updates from WKSHT 2, and WKSHT 4 updates from WKSHT 3. My question is, if I
need a current update in WKSHT 4, do I have to manually open up and update
WKSHT 2 and WKSHT 3 to update WKSHT 4 when values have been changed in WKSHT
1? I know that when you open a spreadsheet it automatically updates, but
what if it is linked to another spreadsheet that also has to be updated?
--
KRR