Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    London
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    worksheet links (97)

    I have an excel file that several users use, it has somehow aquired a link to a file that does not exist - producing an error message when it is opened - ("File not found") - sure enough the file does not exist. I have tried to change the link to point to itself - ie. the spreadsheet with the missing link ( edit menu - links - change source) but when I try to do this I get the following message ("Your formula contains an invalid external reference to a worksheet. Verify that the path, workbook and range name or cell reference are correct and try again")

    I have looked at all the the formula in the spreadsheets using the find dialog box and tried to find the cell containing the formula with the link, however the find dialog box is saying that the file name is not found.

    Where else are links to other workbooks stored other than in cell formulae? Also why when I go to the edit menu and choose links does it say link to worksheet?

    Can any one help me get rid of the link altogether?

    Any help much appreciated.

    Amanda <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    New Lounger
    Join Date
    Nov 2001
    Location
    London
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: worksheet links (97)

    the link did the trick thanks

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

    Re: worksheet links (97)

    Download FINDLINK.Zip from
    http://www.bmsltd.ie/mvp
    It will help you find the link and delete it.

    Edited Mar 13th 2004 to update link
    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
  •