Updating Excel File Links

excel
activities

#1

Hi there,

I am trying to update all the file links in an excel workbook to be changed from previous months files, to current month files (e.g File 0317.xlsx to File 0417.xlsx). The workbook has around 16 different file links and they are referenced in over 100 cells. So I can not do a find and replace in the formulas as there are too many cells.

Is there a quick way of updating file links?

Thanks.


#2

How about replace all?

Ctrl+H


#3

hi.
any solution to this question ?

thank