+ Reply to Thread
Results 1 to 3 of 3

Can't break a link in 2007

  1. #1
    Registered User
    Join Date
    08-27-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    76

    Can't break a link in 2007

    I have a file that was created by using Save As from a previous version. When I open the new file, I get a security warning asking if I want to allow external content. If I click Allow, then Edit Links, I get a window showing a link to the original version of the file (which no longer exists). If I highlight that filename and click Break Links, I hear a ding, but the link is still there.

    Because of corporate security settings, I cannot set the file location as a trusted source, so I am faced with this warning every time I open the file.

    I have tried to find the hidden link in the file by making a copy and deleting things one by one until I no longer get the External Data notice. I narrowed it down to one worksheet (if I delete that worksheet, the notice goes away), then tried deleting the data in that worksheet one column at a time. When I deleted all the data, I still got the notice, so I figured the link was hidden somewhere in the unused portion of the worksheet. I created a new sheet, then copied the data I need, and deleted the old sheet. However, I am still getting the Security Warning, and still cannot break the link.

    Any ideas?
    Last edited by handerson0603; 02-21-2012 at 07:34 PM.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Can't break a link in 2007

    Good evening handerson0603

    Have you tried finding / breaking the link with an add-in? Links can hide in names, charts, OLE objects and loads of other places other than just formulae.
    You could try Bill Manville's add-in here. John Walkenbach's PUP7 has a good link finder / breaker, but really you should pay for this if you are going to use it, but there is an unrestricted trial version you coud use here.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    08-27-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Can't break a link in 2007

    Dominic,

    Thanks for the tip. Bill Manville's FindLink add-in did the trick (even though it had trouble with some checkbox objects and I had to click Abort over 1000 times to get through them). Turns out some cell validation formulas referred to the old spreadsheet.

    kudos,
    Hunter

+ 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