+ Reply to Thread
Results 1 to 4 of 4

How do I break links in a workbook?

  1. #1
    Alwebster6635
    Guest

    How do I break links in a workbook?

    I have 4 worksheets in my workbook that I have linked to a summary file. I
    need to be able to save the summary file as a new file and break the link,
    but the break link button is not appearing on the link box. What do I do?

  2. #2
    Forum Contributor
    Join Date
    06-10-2005
    MS-Off Ver
    2007
    Posts
    223
    Depending on what you need, you could copy and paste the new sheets in the files as values...

    Phillycheese5

  3. #3
    Dave Peterson
    Guest

    Re: How do I break links in a workbook?

    When I can't find links, I'll use Bill Manville's FindLink program:
    http://www.oaltd.co.uk/MVP/Default.htm

    And that break link was added in xl2002 (IIRC).

    Alwebster6635 wrote:
    >
    > I have 4 worksheets in my workbook that I have linked to a summary file. I
    > need to be able to save the summary file as a new file and break the link,
    > but the break link button is not appearing on the link box. What do I do?


    --

    Dave Peterson

  4. #4
    Adrian M
    Guest

    RE: How do I break links in a workbook?

    You can use the Find/ Replace feature to find the links and then manually
    break them. Look at the Find/ Replace video clip on
    http://www.auditexcel.co.za/othertools.html to see how to do it.

    "Alwebster6635" wrote:

    > I have 4 worksheets in my workbook that I have linked to a summary file. I
    > need to be able to save the summary file as a new file and break the link,
    > but the break link button is not appearing on the link box. What do I do?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1