Changing cell location did not cause changing formula

[sebastianws]

Hello Members,
I have got question to you.

I have trouble with mentioned in topic situation. To give you more context, I have 2 files, where 1 (A) is source of data only and the 2 (B) is tool for making actions. I have imported data from A to B - data from A is in B, from this data in B I have selected data in few sheets B1, B2, B3. Everything working fine till we need to add some more data in A file. When somebody did it, it change data also in B but the formulas in B1, B2, B3 stay in all sheets the same. Which mean, when I got ='BinA'!A2 it stays the same, it did not change to ='BinA'!B2 as should be (hypothetically: A column now change to B column).

I did some tries at new files, then did the same actions and it working correctly (change formula as it should be).

A file is at SharePoint, I am not the owner. B file is at OneDrive, I am the owner. May it be a reason?

Let me know if it is understandable.

Thank you for your help.

 

[sebastianws]

Find solution I think... looks like this:

=INDEX([Book1.xlsx]Sheet1!$I:$I,ROW(A2))

Problem probably was because of other owners, when I check it at two files with two other owners the standard formula =locationcell stop working so I check INDEX and it looks like it working right nowe.