Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remove links (Excel 2000)

    I have ranges that I copy from one workbook to another. When they are pasted, the one workbook is linked to the other.
    Because formatting and formulas are the same, I don't want to use Paste Special!
    Any ideas how to remove the links?

  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: Remove links (Excel 2000)

    See this Star Post.

    Andrew C

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Remove links (Excel 2000)

    I've had similar problems, so depending on how your links work this little trick just might work for you too. If your formulas are referencing an external workbook/worksheet but you need them to reference the current workbook/worksheet, you could try Edit | Links | Change Source and select the current workbook as the source for the links. References to the external workbook's sheet will be replaced with references to the current workbook's sheet. This can also work when you have 'mystery' links in your workbook -- when you know you shouldn't have links, can't find any links, but Excel insists that they are there. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  4. #4
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove links (Excel 2000)

    Navigator Utilities has a Link Navigator which provides all the functions that Edit /Links should have. It list all the source workbooks, and for each source, you can display all the links in your workbook. Not just ranges but all those esoteric little links that you can't find such as those hidden in Named Ranges, in Charts, lurking behind buttons in macro references, or even as linked cells behind checkboxes or drop downs etc. With the Link Navigator you can select which links you don't want and simply delete them. You can produce a report of your links, or even produce a report of all linked workbooks from a range or workbooks or a subdirectory of workbooks.

    There are heaps of other tools in Navigator Utilities to help you navigate around Sheets, and Named Ranges as well as an enhanced Find/Replace for those that don't have XP.

    Navigator is a free download at www.robbo.com.au.

    regards

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Remove links (Excel 2000)

    Just looked Navigator Utilities up and it will definitely be being downloaded, and perhaps even registered! It's those non-formula links that are the hardest to track down and eliminate, but that program looks like it'll make child's play out of fixing links. <img src=/S/joy.gif border=0 alt=joy width=23 height=23>

Posting Permissions

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