Martinpetersson
New Member
- Joined
- Apr 27, 2022
- Messages
- 31
- Office Version
- 365
- Platform
- Windows
I have a shared folder located on onedrive.
The folder is shared with people with in my organization
The folder contains approximate 10 excel worksbooks.
In the summary file I used Get data > From File > From workbook
I browsed to my onedrive folder whit all the ten excel workbooks and chose the right workbook to import.
It now works well for me .
But when someone else is trying to open the document excel of course wont find that link because the address go to the local onedrive folder.
Question:
How should I set this up?
I want excel to find and load table data from other workbooks in the same one drive folder.
This should work from all the computers who has access to this folder.
Thank you in advance!
The folder is shared with people with in my organization
The folder contains approximate 10 excel worksbooks.
In the summary file I used Get data > From File > From workbook
I browsed to my onedrive folder whit all the ten excel workbooks and chose the right workbook to import.
It now works well for me .
But when someone else is trying to open the document excel of course wont find that link because the address go to the local onedrive folder.
Question:
How should I set this up?
I want excel to find and load table data from other workbooks in the same one drive folder.
This should work from all the computers who has access to this folder.
Thank you in advance!