Forum Discussion
Juniorscone
Jul 20, 2022Copper Contributor
Bulk updating external links in hundreds of xls files
Good morning, I have hundreds of Xls files in a folder structure....they all have external links to a master data excel file. I am moving that master data file to SharePoint from our local fi...
OliverScheurich
Jul 20, 2022Gold Contributor
=SUBSTITUTE(A1,LEFT(A1,FIND("[Laminates Current New.xlsx]Laminates",A1)-1),"https://company.sharepoint.com/Shared%20Documents/")Is this what you want to do?