Breaking Links in Excel 1

[mathias1979]

Is there a way to break links in Excel while retaining the formula within that cell? In other words, if I have a Workbook called 'Book Two', and in one of those cells I have the following:

"='\\folder\[Book One.xls]Sheet1'$C$5+$D$7"

is there a quick way to change it so it simply references my current workbook, like so:

"=$C$5+$D$7"

I need to do this for lots of cells, and I'd love to figure out a way to shorten the process so I don't have to go in and manually edit the formula for each cell.

 

[DirkStruan]

How about using find and replace, replacing

'\\folder\[Book One.xls]Sheet1'

with nothing?


Dirk

Everything useful perishes through use....Should I not rejoice at being useless?

 

[xlhelp]

Also, Bill Manville has a FindLInk program

http://www.oaltd.co.uk/MVP/Default.htm

Member- AAAA Association Against Acronym Abusers

 

[KenWright]

Edit / Links / Change Source / Navigate to current workbook and hit OK. This effectively removes all the links but leaves the formulas in place.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------