Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: How to change the link source of a single sheet ?

  1. #1
    Board Regular
    Join Date
    Feb 2003
    Posts
    508
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to change the link source of a single sheet ?

    Hello everybody,

    We all know we can change the source of a link of the workbook by clicking Edit>Links>Source>change source but that will change the source of all workbook formulas which are linked to a certain file, what about if i need to change the source of a single sheet? is this possible?

    I appreciate your support.Thank you !
    He who asks a question is a fool for five minutes; he who does not ask a question remains a fool forever.

  2. #2
    MrExcel MVP sanrv1f's Avatar
    Join Date
    Jan 2009
    Location
    Chennai, India
    Posts
    3,468
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to change the link source of a single sheet ?

    did you try simple Find & Replace?
    regards
    Sankar
    show your sheet on the board, get HTML maker


    யாதும் ஊரே, யாவரும் கேளிர்; தீதும் நன்றும் பிறர்தர வாரா

  3. #3
    Board Regular
    Join Date
    Feb 2003
    Posts
    508
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to change the link source of a single sheet ?

    yes but it didnt work
    He who asks a question is a fool for five minutes; he who does not ask a question remains a fool forever.

  4. #4
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    15,982
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to change the link source of a single sheet ?

    Why does find and replace not work?

    Example:
    On Sheet1 in Cell A1 Formula is: =[book1.xls]Sheet1!$A$1
    On Sheet2 in Cell A1 Formula is: =[book1.xls]Sheet1!$A$1

    Now, On Sheet 2 we "Find" Book1.xls and "Replace" Book2.xls

    Result is:
    On Sheet1 in Cell A1 Formula is: =[book1.xls]Sheet1!$A$1
    On Sheet2 in Cell A1 Formula is: =[book2.xls]Sheet1!$A$1

    The link on sheet2 has been successfully changed, and the link on Sheet1 is not altered.

    Alex

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  5. #5
    Board Regular
    Join Date
    Feb 2003
    Posts
    508
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to change the link source of a single sheet ?

    I'll work on that.thank you .
    He who asks a question is a fool for five minutes; he who does not ask a question remains a fool forever.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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