Search code examples
excelexcel-formulaexcel-2010

Replacing file path in excel with another

I have an excel file with cells that retrieve data from a file stored on another computer. I need to update the file path in all of these formulas but it is extremely tedious as each time I update the formula, an open file window comes up. The location that I am changing this to is also not on my computer.

Is there a quick way to update a file path formula without having this dialog window open up?

I need to change my path from

='\\clusfs001nas\

To:

='R:\

Solution

  • Under the "Data" Tab, click "Edit Links" - this should show you the files you have linked to, and you can "Change Source" to update it. Alternatively, you could do a simple Find/Replace (CTRL+F, then click "replace" and type the path you need to replace and then in the replace area, put the new path).