Forum Discussion
Dynamically fetch print area from other workbook on company network
What kind of data connection did you use exactly?
Hi! Thanks for answering.
I have used Get Data>From File>From Excel Workbook, and then essentially also tried the same thing with a Power Query.I see in the connection information that the source document specified is actually the path to the onedrive location on my harddrive, so I understand now why I have to open SOURCE after my colleagues edit it in order for edits to propagate to DEST.
Ideally I would need a path to SOURCE as it lives in the owner's OneDrive cloud location. The owner is a fictive user and has shared access to all its files to me and my colleages, although not to the people who read DEST.
You may use Get Data->From Other Sources->From Web using OneDrive file path, only removing
?web=1
at the end of URL.
File path you may take opening it, File->Info->Copy path
If the people accessing DEST do not have access to SOURCE, they will not be able to refresh that connection. Can you perhaps manage control and give everyone read-only access to SOURCE and yourself read-write access?
