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