Forum Discussion
Dynamically fetch print area from other workbook on company network
I'm trying to prepare a sheet in workbook DEST that contains data fetched upon opening from a print area in workbook SOURCE. This is for the benefit of person X in my company who does not have access to SOURCE, while we both have access to DEST. Both workbooks live in our company onedrive and other people also contribute data to the print area in SOURCE.
I can achieve this by establishing a data connection, but it only works for my changes to SOURCE. They will be propagated to DEST when DEST is opened, provided SOURCE is closed, otherwise a permission error occurs.
Also, if other people contribute to SOURCE while I am away from office, those changes will not end up in DEST until I have opened SOURCE and somehow updated what seems to be "my version" of the SOURCE workbook.
It seems the linking of data is dependent on my credentials.
Is what I want to achieve not feasible with Excel 365?
- can changes not propagate to DEST unless SOURCE is closed?
- Can I not get changes to propagate without having to open SOURCE myself?
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
