Excel spreadsheets linked together

C

CLH929

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

Franz Verga

CLH929 said:
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 ...
Click to expand...


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
 
Top