how i can create a link between two excel workbooks regardless of the path ?

Question

Hi everyone
how i can create a link between two excel workbooks regardless of the path
that is to say when I modify the data of the first workbook, the data in the second workbook will be automatically modified even if the 2 excel workbooks are not in the same location
(Workbook 1 in file 1 and Workbook 2 in file 2 )

Answer 1

https://support.microsoft.com/en-us/office/create-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f#:~:text=the%20source%20workbook).-,Select%20the%20cell%20or%20cells%20where%20you%20want%20to%20create,link%20to%20and%20press%20Enter.