Forum Discussion
How to change Excel links in bulk by recognizing file name
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.
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.
