+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    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)

  2. #2
    Registered User
    Join Date
    03-18-2013
    Location
    Tasmania, Australia
    MS-Off Ver
    Excel 2007
    Posts
    95

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

    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....?

  3. #3
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

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

    Thank u for a quick response.

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

  4. #4
    Forum Contributor
    Join Date
    07-02-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    197

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

    Quote Originally Posted by rajeshturaha View Post
    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

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,837

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

    Is it necessary for C1 to contain the link? One way I might do this is to put the linked value into its own cell (for example, E1). E1=data file C1. C1 in this spreadsheet then becomes =a1+b1+e1. When I am ready to break links, the break links command will break the link in E1 and convert to a value, while C1 retains the formula.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

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

    Thanks a lot, this might help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1