Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break Links But Keep Formulas
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). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break Links But Keep Formulas
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Break Links | Excel Discussion (Misc queries) | |||
Break Links not working !!!! HELP !! | Excel Discussion (Misc queries) | |||
Unable to break links | Excel Worksheet Functions | |||
How do I break links in a workbook? | Excel Worksheet Functions | |||
break links problem | Excel Discussion (Misc queries) |