Excel spreadsheets linked together
CLH929 wrote:
I have a specific quarterly report (B) that is linked to the
information contained in the original monthly financial document (A)
... the Document A has numerous "extra" rows in it ... if I delete
the extra rows, essentially making all of the tabbed worksheets in
Document A the same (which will make it easier for me to update
quarterly in Document B), will the links in Document B change
accordingly with the changes made in Document A or will I need to
re-do all of the links in Document B after I make the changes to
Document A? I know this is confusing ...
It depends on how the two files are linked together...
If they are linked by absolute references, deleting some rows from the
master document (your A document) will not influence the linked file (your B
document). Anyway, it is better delete the rows with both files opened and
then save both.
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|