Page 1 of 2 12 LastLast
Results 1 to 15 of 24

Thread: removing links

  1. #1
    whigham
    Guest

    removing links

    In Excel 2000, I'm trying to create a new budget from last year's, and somewhere in last year's file there are links between months, so that some cell in, say, December reads its data from the November screen. Is there a way to copy the December page from this file to make the new year's January screen without importing such internal links, so that the 2001 budget does not generate (upon opening) the update links, yes/no message? Put another way, how can I find and cut such links?

    Thanks.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: removing links

    Will copying the December worksheet and doing a Paste Special/Values (then maybe a Paste Special/Format) do what you want?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: removing links

    After you copy your December file and make it to January or whatever, Select Edit, Links. The Links dialog box should appear. Click on the link (in EXCEL97there is a liottle bar below which shows the name of the file or sheet linkage that you selected). Then Click the Change Source button and change the link to the active file or sheet that you now want to link to. If that does not work, then.Select Insert, Name, Define. Scroll down the list in the Define Name dialog box and examine the "Refers to" box. Delete names that refer to another workbook or that contain an erroneous reference (such as #REF!). This is the most common cause of "phantom
    links."

    [img]/w3timages/icons/laugh.gif[/img]

  4. #4
    pcc
    Guest

    Re: removing links

    I found a small utilty, FindLink that you install which makes it easey to find most links.
    I have a copy of the zip file is someone would advise me where to send it so it is available to all.

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

    Re: removing links

    Is there a web site for this? It sounds good.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  6. #6
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: removing links

    <P ID="edit"><FONT SIZE=-1>Edited by gwhitfield on 01/01/15 23:15.</FONT></P>*** I've added tags to the web reference- but it's put my sig in place of Gene's ***

    The only item that I've seen while surfing Excel links that fits this description is the one from MacroSystems which is shareware. See: http://www.add-ins.com/linkfind.htm

  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

    Re: removing links

    Thanks Gene- looks good. But I don't know why it replaced your sig with mine- sorry.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  8. #8
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: removing links

    I've seen that happen a few times -- and even to HRH.

    HELP, MUMMY! The signature switcher gremlin is alive.

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

    Re: removing links

    Gene-

    Is it shareware? I've looked at the link and it looks as if you have to purchase a VB suite of programs to get it.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  10. #10
    pcc
    Guest

    Re: removing links

    Hi Geoff,
    Sorry, the only information that I can find is that it is written by Bill Manville. I picked this utility up from a recommendation in a newsletter some time ago, but cannot recall which one. I have a number of users throughout the company using this utility, and they all love it.
    I still have the original zip file, so I can send this to you in an email if you give me your address, as it is only 10.8KB.

  11. #11
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: removing links

    There is a delinker you can get from the Microsoft website. Just search for dellinks.xla.

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

    Re: removing links

    cpod,

    Thanks for that. Here's the link
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

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

    Re: removing links

    Paul,

    That's OK. I found it here
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  14. #14
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: removing links

    Geoff, it's part of a package of Excel utilities that are for sale. I also have the Bill Manville file which I'd forgotten about. The link you've already included in your post is accurate and should be sufficient. I double checked the download and it looks to be still valid.

  15. #15
    Star Lounger
    Join Date
    Jan 2001
    Location
    Switzerland
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: removing links

    Hello,

    I different approach is to use the INDIRECT function - no more "internal links" !

    Regards

    --alex

Page 1 of 2 12 LastLast

Posting Permissions

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