Forum Discussion
How to change Excel links in bulk by recognizing file name
Dear Team, I am now preparing monthly budget-forecast review workbook "Jan forecast.xls" (Destination workbook). In order to prepare this, I will use numbers linked to several workbooks "Jan exp.xl...
AngeloRussel Have you tried Excell's built-in tool "Find and Replace" option, Ctrl-H?
Fill in Jan exp in the Find what: field
Fill in Feb exp in the Replace with: field
Repeat this for the other file names in your links.
Under Optons tell it to apply the find & replace to the entire workbook. That should do it.
Riny_van_Eekelen Hi Riny, thank you for the response! Yes, I've tried the "Find and Replace" option but since the file name (ex. Jan exp) is also in the spreadsheets but I dont want to update it to Feb exp. Thus, this is to seek if there's any other tools/ methods can update the links in a batch (ex. replace bunch of old links to new links) instead of using the Data->Edit link method? thank you.