Update information from source file without opening

Frequent Visitor

Hi everyone,

 

I have a normally setup Sharepoint with different folders (f.e.) Folder 01, 02, 03 etc.. In folder 01 i have a masterdata tabIe (excel) which I need to fill some other excel files in folder 02, 03 etc.. In this case i have 2 issues at hand:

- When I move a file from folder 01, 02 the direct link i have in the destination files changes to folder 02, while the masterdata table is still in folder 01.

- The other issue is that the table in the destination file only updates the values when the source and destination file are open at the same time. I use direct links and the files are on the same Sharepoint, only in a different folder.

 

Any suggestions? Would be much appreciated!

Ben

0 Replies