Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Nov 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    spreadsheet links to other spreadsheets (97 SR2)

    Hi there

    Is there a VB script or Excel menu item I can run / choose to show me cells that are linking to other spreadsheets. I have 20 + sheets in a spreadsheet that I think does not have any links to other sheets but when I open it asks if I want to update the spreadsheet to the linked sheet.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: spreadsheet links to other spreadsheets (97 SR2)

    Have a look at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=30606&page=&v iew=&sb=&o=&vc=1#Post30606>this post</A>
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Rockford, Illinois, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: spreadsheet links to other spreadsheets (97 SR2)

    Try Edit/Links and it will show you the links associated with your worksheet. You can break the links from there too.

  4. #4
    Lounger
    Join Date
    Nov 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: spreadsheet links to other spreadsheets (97 SR2)

    Edit links shows me 4 sheets that think that they are linking to this one.

    Can I see what cell(s) may be calling that linked sheet?

    I can update which will presumably try to access the linked file which I do not want, I can Open source, which should not break the link, and change source - I do not think that there are any cells linking and want to remove not update the link.

    What do I do in edit links to break the link?

    thanks for the help

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Rockford, Illinois, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: spreadsheet links to other spreadsheets (97 SR2)

    Go to the post Geoff refers to and download the addin. It is slick. It will show you the links and ask if you want break them one by one. It adds the find link command to the Tools menu.

  6. #6
    Lounger
    Join Date
    Nov 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: spreadsheet links to other spreadsheets (97 SR2)

    I have used the delete links wizard from Microsoft:

    It is at http://www.microsoft.com/office/excel/support/97.htm
    XL: Delete Links Wizard Available (Q188449)

    It has removed the links for me, and shown me where they were.

    Hidden defined names were embedded in the file that were linking to other sheets.

    thanks for the help

Posting Permissions

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