How to Break external refference link without converting formula to value within sheet.

Dear all,
Hello
I m new to this forum, and this is my first thread, plz help.
I have a formula in a cell which is refered to other cell within the same sheet and also to other sheet from other file. say
C1 = A1+B1+data file c1
Data file is another file in other location.

I was trying to break a external reference link (from Data File) from Data _ Edit Link, but it is converting all the formula to value.
How is it possible to break only the external link without damaging the formula within the sheet
say c1 = A1+B1+26 (value from data file c1)

do you want to break the link and change it to anaother location?

You can do this from Data - Connections.

Or do you want to convert the linked file to numbers and keep the formula for the active workbook references live....?

Thank u for a quick response.

I want to convert the linked file to number and keep the formula for the active workbook live

Originally Posted by rajeshturaha

How is it possible to break only the external link without damaging the formula within the sheet
say c1 = A1+B1+26 (value from data file c1)

Yes you have to put a fixed value instead of the external link in your formula as you said:
C1: =A1+B1+26

Thanks a lot, this might help.