Dynamic reference to Sharepoint files using formula?

Occasional Contributor

Hello~

 

I would like to create a bunch of workbook links to another excel file (both files on SharePoint/OneDrive) using the format specified on https://support.microsoft.com/en-us/office/work-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d7...

mayysyeung_0-1658161654144.png

, in which I would like part of the folder, the filename and also the sheet name and cell name to be dynamic. I tried constructing the link using "&", "concat" function and / or wrapping the whole thing with the "indirect" function, but none can work except typing the whole link intact into the cell.

 

Is that true that the function could not be used as I wish or I have missed out something during my tries? :')

0 Replies