Break Links But Keep Formulas

[Tim879]

Does anyone know how to break links to an external file but still keep
the formula?

For example

if I had a formula as follows: ='[some external file]sheet1'!A1 *
5000. Assume '[some external file]sheet1'!A1 = 100.

I would like the value of 100 * 5000 in the cell

If you use Edit-> Break Links, then it just puts the value in the cell
(500000 in the case above).

 

[Gary Keramidas]

try bill manville's utility

http://www.oaltd.co.uk/DLCount/DLCount.asp?file=FindLink.zip

 

[Tim879]

I tried the tool you suggested but it pretty much does the same thing
as Edit -> Links -> Break Links.

It doesn't keep the non-linked portion of the formula intact.

try bill manville's utility

http://www.oaltd.co.uk/DLCount/DLCount.asp?file=FindLink.zip

--

Gary

Does anyone know how to break links to an external file but still keep
the formula?

For example

if I had a formula as follows: ='[some external file]sheet1'!A1 *
5000. Assume '[some external file]sheet1'!A1 = 100.

I would like the value of 100 * 5000 in the cell

If you use Edit-> Break Links, then it just puts the value in the cell
(500000 in the case above).