+ Reply to Thread
Results 1 to 7 of 7

Updating/changing links in Selected Cells

  1. #1
    Registered User
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    92

    Updating/changing links in Selected Cells

    I have an excel spreadsheet with links to various workbooks


    I would like know how to update or change the links for selected cells only.

    When trying to change links for selected cells, Excel changes all the links



    Your assistance is most appreciated
    Last edited by Howardc1001; 12-07-2018 at 10:21 AM.

  2. #2
    Registered User
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    92

    Re: Updating/changing links in Selected Cells

    Have also posted on the link below

    https://www.mrexcel.com/forum/excel-...ells-only.html

  3. #3
    Registered User
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    92

    Re: Updating/changing links in Selected Cells

    Attached please find workbook “Average Sales Data” I would like to amend source link for cells C2:C4 to ‘Sales –Oct 2018 to Sept 2018.xls, without amending any other links


    When I select this range and go to edit links, and change source, then all the other cells which have links are also changed

    Is there a way to any update the source file for certain cells in Excel or an add-in that can do this ?


    It would be appreciated if someone could advise me regarding this

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,691

    Re: Updating/changing links in Selected Cells

    Maybe try Find/Replace?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

  5. #5
    Registered User
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    92

    Re: Updating/changing links in Selected Cells

    Good idea, thanks

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,138

    Re: Updating/changing links in Selected Cells

    I suggest you, you change the data structure. As per your file lot of blank rows & columns, delete unnecessary blank rows & columns.
    I have attach similarly link file. You are gone through that, accordingly do the needful. Hope this will get more helpful.
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  7. #7
    Registered User
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    92

    Re: Updating/changing links in Selected Cells

    Thanks for your help, much appreciated

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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