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