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...
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.
AngeloRussel Would it work if you use Jan exp.xlsx ?
Or, if your sheet contains a cell with a text like, "Jan expenses", consider entering "Expenses January" in stead. Just so that the actual file names used in the links are not used as a text in the sheet as well.