Find Replace Making Me Open and Select Other Files

[doug firr]

I ahve a report that I must update each week.

Throughout the report are references to another daily report of the format:

20140610_DailyReport

So each week when it comes to updating I am supposed to CTRL+H and replace 20140603_DailyReport with 20140610_DailyReport

But when I try that now excel is opening windows explorer and for each cell where the change is made, I have to select the file in question. It's really annoying.

How can I CTRL+H to update the path of the report being referenced without having to manually select each path for each cell?

 

[doug firr]

Figured it out. Had to use "Update Links" within data options menu rather than use CTRL+H to find/replace