Forum Discussion
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 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?
8 Replies
- Hi..
how are you retrieving the data ?
Regards, Faraz Shaikh- Hi Faraz,
I retrieve it by typing "=" and then choosing the cell in the source document with the data I want to retrieve.Frallan13 wrote: I retrieve it by typing "=" and then choosing the cell in the source document with the data I want to retrieve.
The "=" part is given. Then we have to ask "How to you choose the specific cell in the source document?" Do you remember the column and row address?
I have a master spreadsheet that pulls in data from two source sheets. I usually have the source sheets open when doing so, so this may not be relevant. From time to time the numbers of rows in the source sheets change, sometimes up, sometimes down. I use COUNT to count the rows, and then INDIRECT to modify references accordingly. Something for you to try if it's at all relevant.
