Excel spreadsheets linked together
 

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 ...

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