Retrieving data from another closed Excel-file

%3CLINGO-SUB%20id%3D%22lingo-sub-2155815%22%20slang%3D%22en-US%22%3ERetrieving%20data%20from%20another%20closed%20Excel-file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2155815%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3CBR%20%2F%3EI%20have%20two%20Excel-files%20saved%20on%20Teams%20in%20seperat%20folders.%26nbsp%3B%3CBR%20%2F%3EOne%20of%20the%20Excel-files%20is%20retrieving%20data%20from%20the%20other%20(source%20document).%26nbsp%3B%3CBR%20%2F%3EI%20have%20noticed%20that%20when%20I%20add%20a%20row%20in%20the%20source%20document%20while%20the%20retrieving%20document%20is%20closed%2C%20the%20retrieving%20document%20is%20then%20retrieving%20the%20wrong%20row%20when%20opened.%26nbsp%3B%3CBR%20%2F%3EThe%20retrieving%20document%20understands%20that%20a%20row%20has%20been%20added%20if%20it%20is%20open%20while%20the%20change%20is%20made%20to%20the%20source%20document.However%2C%20it%20is%20not%20always%20that%20I%20remember%20to%20open%20the%20retrieving%20document%20while%20making%20changes.%26nbsp%3B%3CBR%20%2F%3EIs%20there%20a%20way%20to%20work%20around%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2155815%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 document while the retrieving document is closed, the retrieving document is then retrieving the wrong row when opened. 
The retrieving document understands that a row has been added if it is open while the change is made to the source document.However, it is not always that I remember to open the retrieving document while making changes. 
Is there a way to work around this?

0 Replies