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.