Excel : Link between files broken in network

Hello,

I have made some separate excel files that are related to show some statistics and information in my Network.

However, after closing one of them its giving me an error : #REF

one of my code : ='S:\Commercial\Vente\PROSECTION\FA BDD.xlsm'!Tableau3[@Total]

The begining of my affectation and linking is working perfecrtly but after closing it gave me this error !!

I have been working in it for days, if you could help me to solve it it will be indeed amazing.

Kind regards guys

Still no solution guys !! any help !!!