Link to Excel 365 spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3307903%22%20slang%3D%22en-US%22%3ELink%20to%20Excel%20365%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3307903%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20Office%20365.%20I%20have%20a%20spreadsheet%20on%20sharepoint%20that%20is%20updated%20nightly%20named%20spreadsheet1.xlsx.%20The%20link%20to%20the%20spreadsheet%20looks%20similar%20to%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fxxx.sharepoint.xxx.domain.com%2FSS%2FFolder-name%2FThis%2520is%2Fthe%2520Folder%2520Inventory.xlsx%3Fd%3Dw1zyrw21123ef66e6baf6d666c6c6365b7%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fxxx.sharepoint.xxx.domain.com%2FSS%2FFolder-name%2FThis%2520is%2Fthe%2520Folder%2520spreadsheet1.xlsx%3Fd%3Dw1zyrw21123ef66e6baf6d666c6c6365b7%3C%2FA%3E%26nbsp%3B.%26nbsp%3B%20I%20want%20to%20use%20Xlookup%20to%20query%26nbsp%3Bspreadsheet1.xlsx%20and%20pull%20the%20data%20back%20into%26nbsp%3Bspreadsheet2.xlsx%20which%20is%20also%20on%20Sharepoint.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3307903%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.

0 Replies