External reference help

jmenche

New Member
Joined
Jun 2, 2006
Messages
26
Hi,

I have a spreadsheet with a lot of external references to a file on a network. I want to change the network path. However, when I select all cells and use the built-in Replace function, it wants to go cell by cell and open the source file. Is there a way to turn this off so I can do a simple text replace?

Thanks

Jeff
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

ChrisM

Well-known Member
Joined
Jun 11, 2002
Messages
2,129
Use Find/Replace to kill all your formulas. replace = with a dummy character, like #. Now you just have a bunch of text strings that you can edit via text replace. Lastly, replace all # with = and your formulas are restored.
 

jmenche

New Member
Joined
Jun 2, 2006
Messages
26
Sadly, the same problem happens when you replace the # with the =. There seems to be no way around this. Each cell has a reference.
 

ChrisM

Well-known Member
Joined
Jun 11, 2002
Messages
2,129
Probably best then to open the source file(s) first, then rename the links, then you won't see s delay
 

Watch MrExcel Video

Forum statistics

Threads
1,109,033
Messages
5,526,363
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top