Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked Objects (2000)

    How can I find where in a workbook a linked object is physically located? I see the linked object in the Edit/Links dialog box, but I don't know where it actually is. Any ideas?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Linked Objects (2000)

    An additional comment to Jim's note:
    Named ranges are often a place where there are "hidden" links. If you copy/move sheets from 1 workbook to another, will have the names (which are WORKBOOK objects) moved and added added to your names in the NEW workbook. Many will get transferred as LINKED cells if they refer to a sheet that was NOT moved (these can be deleted if desired)

    Steve

  3. #3
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Linked Objects (2000)

    <P ID="edit" class=small>(Edited by Leif on 13-Mar-04 16:35. to update link to http://www.bmsltd.ie/)</P>You can search the sheets in your workbook for "[" and the link might show up.
    Excel encloses references to other workbooks in brackets [ ].

    Or you might try Bill Manville's Link Finder at:
    http://www.bmsltd.ie/mvp/
    It is very popular and has thousands of downloads.

    Or you might try my "Locate Links" Excel add-in.
    It is slightly easier to use and one option provides a listing of links in the workbook.
    Each item listed has a hyperlink that takes you to that item.
    I've attached the one page Word.doc instructions for the Add-in.
    It is available for free upon direct request to jim.coneXXX@rcn.comXXX
    (remove xxx)

    Jim Cone
    San Francisco, CA

Posting Permissions

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