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).

try bill manville's utility

http://www.oaltd.co.uk/DLCount/DLCou...e=FindLink.zip

--


Gary


"Tim879" wrote in message
...
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).

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.

On Jun 16, 10:36 pm, "Gary Keramidas" <GKeramidasATmsn.com wrote:
try bill manville's utility

http://www.oaltd.co.uk/DLCount/DLCou...e=FindLink.zip

--

Gary

"Tim879" wrote in message

...

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).