-> It seems that 2 files having a same link (to a third file) cannot have 2 different values...
Let me show you with an example :
Create a file "Source.xlsx" : cell A1 contains 'TOTO'
Create a file "A.xlsx" : cell A1 contains a link to ='D:\[Source.xlsx]Feuil1'!$A$1
Create a file "B.xlsx" : cell A1 contains a identical link to ='D:\[Source.xlsx]Feuil1'!$A$1
Save and close all; then open again Source.xlsx and A.xlsx to change 'TOTO' to 'TITI'
Save and close all again
Now comes the fun !
Open A.xlsx; clicking "Do not update" : you can see 'TITI' (normal)
Without closing A, open B.xlsx (do not update neither) : you see 'TOTO' (normal)
switch back to A.xlsx, and now 'TITI' has become 'TOTO' !!!
Case 2 : without saving; cosoe all and open first B.xlsx; and then A.xlsx.
Now it's B.xlsx that has lost its initial value and has become 'TITI' (!!!)
What I see is : the value from the link of the file that has been last open replaces the value of all other identical links of other files...
Any idea to "solve" this ?
Simon
Let me show you with an example :
Create a file "Source.xlsx" : cell A1 contains 'TOTO'
Create a file "A.xlsx" : cell A1 contains a link to ='D:\[Source.xlsx]Feuil1'!$A$1
Create a file "B.xlsx" : cell A1 contains a identical link to ='D:\[Source.xlsx]Feuil1'!$A$1
Save and close all; then open again Source.xlsx and A.xlsx to change 'TOTO' to 'TITI'
Save and close all again
Now comes the fun !
Open A.xlsx; clicking "Do not update" : you can see 'TITI' (normal)
Without closing A, open B.xlsx (do not update neither) : you see 'TOTO' (normal)
switch back to A.xlsx, and now 'TITI' has become 'TOTO' !!!
Case 2 : without saving; cosoe all and open first B.xlsx; and then A.xlsx.
Now it's B.xlsx that has lost its initial value and has become 'TITI' (!!!)
What I see is : the value from the link of the file that has been last open replaces the value of all other identical links of other files...
Any idea to "solve" this ?
Simon