I'm using Office 365. I have a spreadsheet on sharepoint that is updated nightly named spreadsheet1.xlsx. The link to the spreadsheet looks similar to this https://xxx.sharepoint.xxx.domain.com/SS/Folder-name/This%20is/the%20Folder%20spreadsheet1.xlsx?d=w1... . I want to use Xlookup to query spreadsheet1.xlsx and pull the data back into spreadsheet2.xlsx which is also on Sharepoint.
Any help would be greatly appreciated.
