Retrieving data from another closed Excel-file

Hi! I have two Excel-files saved on Teams in seperat folders.  One of the Excel-files is retrieving data from the other (source document).  I have noticed that when I add a row in the source docum...