Breaking Links In A Formula And Making Them Values, Office 2003

[tcohen]

Hi,



I have a few tabs in a spreadsheet and alot of the cells on the tabs are formulas that link to a cell in my current spreadsheet and then to an external spreadsheet.


an example is -


=+ACTUAL!CO293-'N:\common\HF\Budgets\2012[Budget2012.xls]ACTUAL'!CO293

What I would like to do is find a way where I can make the second part of the formula (the part that links to external spreadsheets a value (the current value the link is picking up) instead of a link. I tried the break link option but that makes the whole cell a value. I would like to keep the first part of the formula "=+ACTUAL!CO293" as is and just make the part after the subtraction sign a value (the current value the link is picking up). Is there a way to do this?

I have to do it to about 3 tabs, with like 400-500 cells on each tab. The tabs also all link to different external workbooks.

I see there might be a way to do this with edit & replace but have not been able to figure it out.

Thanks for any help

[OTPM]

Hi
Can you post an example of current and desired so we can see exactly what you are after.
Initially if I understand you correctly, the only way you can replace the second part of the formula is to actually type in the value you are linking to which actually defeats the object of a formula.
Tony