+ Reply to Thread
Results 1 to 3 of 3

Break link will not go away

  1. #1
    Registered User
    Join Date
    06-23-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    14

    Break link will not go away

    I have a user using Excel 2007, who copies a sheet to a new workbook. The user clicks Office Button, Prepare, Edit Links to Files menu to reach the link dialog box.
    Clicks Break Link button, then clicks the second Break Links button.
    Closes the Edit Links dialog box to complete the steps.
    Then clicks back on Office button etc. to bring up the Edit Links dialog box and the link is still showing up.
    Edit Links to Files is still on the Prepare menu, and the file is still in the dialog box.
    For everyone else the menu is gone when these steps are followed.

    Any one have any idea why the menu selection is not going away.
    We check the cell in the spreadsheet and there is no longer a link, just the value.

    Thanks, Jesseb

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Break link will not go away

    For everyone else the menu is gone when these steps are followed.
    For the same file or a different file?

    There may be links to other workbooks hidden in defined ranges, constants, data validation. These must be manually corrected to break the links for good.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Break link will not go away

    Hi,

    ...and further to teylyn's list the ones that sometimes catch me out since they're less obvious, are those links in range names and particularly in macros attached to sheet objects like pictures, buttons and the like.

    Rgds
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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