Results 1 to 4 of 4
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't break links (Excel 2003)

    I have a workbook where I wrote code to copy one sheet to its own workbook. The code renames the sheet, gets a workbook name from the user, breaks the links to the source workbook and saves itself. Everything works except the breaking the links. Even when I do it manually via Edit/Links, the links remain with no error message (in code or when I do it manually). This sheet has links to other sheets and some pictures (done via the camera tool) of some charts and tables. The links in the pictures break fine but not the normal cells. I want the formulas replaced by their values.

    When I open this newly created workbook, I do get warnings about links but I do not update. When I go to Edit/Links I click 'break links' I get the normal confirmation message, but nothing happens. The parent workbook is still listed in the dialog and links remain. It must be something about this workbook as I can do this fine on a test workbook I made manually. This workbook isn't protected so I can't think of what might cause the links to remain.

    Any ideas?

    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't break links (Excel 2003)

    Have you tried Copy, then Paste Special > Values for the cells containing external references (either manually or in code)?

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Can't break links (Excel 2003)

    Do you have any named formulas or ranges (via insert - name -define)? They often are created when whole sheets are copied. All names are copied into the new book and the names referring to other sheets become external links.

    Steve

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't break links (Excel 2003)

    You could also - s/t restructuring issues - try Move Sheet (instead of Copy Sheet) in your code. HTH
    Gre

Posting Permissions

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