Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tracing a link? (Excel 2003)

    Anybody know how to trrace a link in a spreadsheet?( I am trying to find the linked cell/s). I have tried to switch to formula auditing mode and try to find it that way but no luck. And I just don't want to brake the link as it will hardcode my formula, which is not what I want to do. Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tracing a link? (Excel 2003)

    Do you want to find a link to an external workbook? If so, you can search for the text <code>.xls]</code> across all sheets, matching part of the cell and looking within formulas, for an external link is of the form
    <code>
    ='[workbookname.xls]sheetname'!cellreference
    </code>
    so it should always contain <code>.xls]</code>.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracing a link? (Excel 2003)

    Look for findlink from Bill Manville:
    http://www.oaltd.co.uk/mvp
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: Tracing a link? (Excel 2003)

    For the benfit of others who have encountered annoying 'workbook links':
    The presence of 'links' in a workbook can be seen when you select Edit->Links from the top-panel Excel command bar.
    (If the Links option is greyed out - you don't have any!)

    Hans describes your first line of attack - use Ctrl-F (Find) to search each of your sheets for .xls]

    If a sheet has been copied from another workbook into the current workbook, it will typically also 'import' range names that were set in the other workbook.
    You should therefore also check any assigned range names : use Insert->Name->Define and check the Refers to: for each entry.

    Also, if you have any objects, images etc that have been copied from another workbook (they may have ad macros assigned to them inthe other workbook) -right-click the object and check assigned macros -delete or update as necessary.

    In many cases, I have been able to get rid of 'links' by using Edit->Links and then changing the indicated source file(s) to the 'current' file
    (You have to browse and point to the current file)

    Hope this helps

    zeddy

Posting Permissions

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