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?
