Change formula content in reference cells.

[Kwadrat2323]

Hello everyone,
I have a big problem in my excel file.
I created a data base which is "dowloading" data from 44 different excel files. The problem is: in my cells, formulas are different for one reference file (I have no idea how and why). Let me explain it:

Reference file is in folder IRS located on my desktop, so I use the formula: = IF($B$1=$B$180;'C:\Users\XYZ\Desktop\IRS\[BA.Shopping.xlsx]XYZ Efficiency 2015'!M8), but in 2600 cells (out of 4000) formula is =IF($B$1=$B$180;'C:\Users\XYZ\Desktop\masterfile\photos\[BA.Shopping.xlsx]XYZ Efficiency 2015'!M68). I have no idea how did it happen. Can someone tell me how can I change it without manual inputting cell by cell? I tried to use find and replace all but it didnt work as I expected becasue I needed to confirm the reference file one by one...
Thank you in advance,
KC

 

[Snakehips]

Kwadrat2323,

Welcome to MrExcel.

Use Edit Links >> Change Source >> Browse & Select new source

Eg Edit Links is in the Connections area of the Data tab in 2007.
You will need to remove any protection whilst editing the links.

Hope that helps.

 

[Kwadrat2323]

Thank you Snakehips,
but is there any way to change formula content in fast way?

 

[Snakehips]

Thank you Snakehips,
but is there any way to change formula content in fast way?

How is this not fast?