View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default 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