Results 1 to 7 of 7

Thread: removing links

  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    removing links

    edit > links shows the files that the current workbook links to. Sprisingly there's no option to delete a link.
    Any ideas how I do this?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: removing links

    What you need to do is locate every formula with a reference to an external source and delete/edit such references. Links can also be attached to other objects, pictures, buttons etc. Try the following thread for ideas and links to other threads ans utilities that will assist you :

    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=21519&page=&view= &sb=&vc=1>Excel 97 External Remote References </A>

    If you know where the links are you could just select the cells in question and copy and paste special values. Just be sure that is what you want.

    Andrew C

  3. #3
    Lounger
    Join Date
    Oct 2002
    Location
    Mackay, Queensland, Australia
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: removing links

    This has always been a problem with Excel. But there's a special little add-in file called Findlink.xla that will do this for you. It comes in as an add-in on the Tools menu. I can't remember where I originally got it from - it was free. I have attached it for you. It works a treat. Finds the links and then gives you the opportunity to remove them.
    Attached Files Attached Files

  4. #4
    Star Lounger
    Join Date
    Jan 2001
    Location
    WNC USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing External Links to another Workbook

    Thanks Geoff ... I have downloaded both these but have yet to try them ... one of my goals today. Dang virus got me this week so other things got put aside.

  5. #5
    New Lounger
    Join Date
    Jul 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing External Links to another Workbook

    THANK YOU!!!

    microsoft help was useless

  6. #6
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing External Links to another Workbook

    Thanks for this. I will give it a try.
    Regards

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

    Removing External Links to another Workbook

    It's not an uncommon problem to have a worksheet which, when you open it, you get messages to say something like "This workbook is linked to another worksheet- do you want to refresh". It can be very difficult to track down these references.

    The one you have attached is by Bill Manville from The Excel MVP Page.

    Edited by HansV to update link that no longer worked
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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