Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Finding Links (Excel 97)

    In a workbook that contains formulas to many linked spreadsheets, how can a user find the specific cell with the link and then amend/delete that link as appropriate? (without looking in each cell of each spreadsheet)

    Is there a find feature that can be used here?

    The only way I can think at present would be to format the cell with the linked formula at the time of creation. However this is not possible where you inherit a workbook from somewhere else.

    I look forward to a response.

    Thanks

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

    Re: Finding Links (Excel 97)

    Download FINDLINK.ZIP from the Excel MVP page listed below.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Finding Links (Excel 97)

    Hi,

    One simple way, if you know the name of the link (which you can get via Edit|Links), is to do a 'Find' for that string. Excel will take you to each linked cell on the active sheet in turn for editing, without you having to check all cells.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    Star Lounger
    Join Date
    Jan 2001
    Location
    Newcastle, New South Wales, Australia
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding Links (Excel 97)

    A link to another workbook contains the filename in square brackets, so if you don't know the exact link, then you can try Edit Find for "[" or for "]" and get to the cell that contains the link.
    (It doesn't seem to work quite so easily if the link is within a chart - I don't know how to do that yet.)
    Ruth

  5. #5
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding Links (Excel 97)

    Thanks kindly for your response.

    Cheers,

    Jocelyn

  6. #6
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding Links (Excel 97)

    Thanks kindly,

    regards,

    Jocelyn

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

    Re: Finding Links (Excel 97)

    Links can live in many objects. That is why FINDLINK (which I mentioned earlier in this thread) has been made available by Bill Manville.

    It searches:

    - commandbutons
    - any shape on a worksheet (including charts and the objects on them)
    - dialog sheets
    - names
    - all cells

    and whatever else I might have forgotten <img src=/S/smile.gif border=0 alt=smile width=15 height=15>.
    Also a very nice utility if you're looking for a specific string anywhere in a workbook.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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