Jan 23 2021 04:28 AM
Hi,
Scenario.
Multiple Excel files stored in SharePoint.
Using Get data to make a report. From Fil, From folder (SharePoint is not an option in my Excel)
Problem, the source path is locked to my User: C:\Users\Geir Hogstad\ So other users receiev error when they update.
Is is possible to make the path "universal" so every users with access to the Sharepoint site can update?
Best Regards
- Geir
Jan 23 2021 11:40 PM
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more.
Jan 25 2021 12:48 AM - edited Jan 25 2021 04:20 AM
Thank you @Faraz Shaikh I have the Office 365 Bussiness Standard edition.
I think SharePoint option is "From Online Services" under the Get-menue. And its not an option.
2. What should the universal path look like?
Is it possible to change it in teh settings for datasource?
Best Regards
- Geir
Best Regards
- Geir