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

You the replace menu option (edit - replace).

Put in the From box

'[some external file]sheet1'!

Put nothing in the to box and Replace ALL. Make sure in the advance option
that look in formulas is set.
"Tim879" wrote:

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