Forum Discussion
Refreshable Connections via Sharepoint
I've created an excel sheet that pulls data from two excel online sheets that are linked to forms filled out on a weekly basis. Because it's in my onedrive, I'm the only one who can refresh it, w...
Hey ChrisMendoza ,
My issue is that when I choose Get Data and then try to find the file, I'm unable to locate it because the only options I have are either to find it in OneDrive or import a list from Sharepoint. I'm trying to import the file from Sharepoint.
Does that make sense?
Topher11 -
Similar to what SergeiBaklan is saying, except that navigation within the ribbon is not working like that.
I ended up using New Query > From Other Sources > From Sharepoint List.
In the 'Navigator' window, select an existing list then EDIT.
Remove any steps, leaving only Source.
It should be showing:
'=SharePoint.Tables("...")'
Change to:
'=SharePoint.Files("...")'
You should be able to see your Excel, CSV, etc. files.
