Forum Discussion
dynamic excel list via oneDrive
Dears, I am after a solution to reflect my permanent dynamic excel list, wich I have safed in OneDrive, into a new worksheet, which I can change/amend and share with a new contacts via OneDrive. Spe...
If you try to combine few files and you are on OneDrive For Business, use File->From SharePoint Folder connector with URL like
https://<tenant>-my.sharepoint.com/personal/<account>
On next step filter it on the path you use.
If you'd like to query exact file, open it, File->Info->Copy Path (assuming it is on OneDrive).
In another file to connect it Data->From Web->paste URL and remove at the end of the URL text
"?web=1".
When click Ok.
- thanks for you effort, but it is not working at my place....
What exactly doesn't work and on which step? Also, which OneDrive you use, for Business or consumer one?
- working with Excel Microsoft 365 buisness
"File->From SharePoint Folder connector with URL like" where is this to find?
I am working in our shared Excel list on OneDrive