+ Reply to Thread
Results 1 to 7 of 7

Can't break or even find link to get rid of update links popup

  1. #1
    Registered User
    Join Date
    04-29-2014
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    Can't break or even find link to get rid of update links popup

    When I open this file, it keeps asking me to update the links. I've tried breaking the link, but it won't break. I cannot find where the link is. I've looked in the Name Manager, in the macros, in the Conditional Formatting, and in searches through the formulas and values, as well. Can any of you see where it is or how to fix the problem? This is a file all the execs in my company look at and update weekly, so this popup is really embarrassing. I would really appreciate your help. Thanks!!

    Compiled Dept WIGs Tracking-Reporting - 2014 08 18.xlsm

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Can't break or even find link to get rid of update links popup

    To remove link go to Data, Connections and click Remove and OK.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    04-29-2014
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Can't break or even find link to get rid of update links popup

    Thank you for your response. The only data connection I see in this file is the one to the PowerPivot table, which I need. I tried making a backup and breaking it anyway, but it did not get rid of the link. Is there anything else you can think of to try?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Can't break or even find link to get rid of update links popup

    You have data validation list using, ='C:\Users\larce\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\KK5ED496\[Copy of Compiled Dept WIGs Tracking-Reporting - 2014 07 02_AL.xlsm]Lookup'!#REF!

    Hidden Temp sheet G2:G4 and R2:R5
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    04-29-2014
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Can't break or even find link to get rid of update links popup

    That fixed it!! Thank you SOOO much!! Do you mind if I ask how you found that (in case it happens again)?

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Can't break or even find link to get rid of update links popup

    Use this free addin. FindLinks
    http://www.oaltd.co.uk/MVP/Default.htm

  7. #7
    Registered User
    Join Date
    04-29-2014
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Can't break or even find link to get rid of update links popup

    Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto update links and remove the popup box
    By AV1D in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2012, 03:58 PM
  2. Links Within Tabs - Break Link In One Tab But Keep In Another
    By SEOT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2008, 03:55 PM
  3. Can't find Edit, links dialogue box to break the link
    By Angie L. in forum Excel General
    Replies: 1
    Last Post: 10-13-2005, 06:05 PM
  4. [SOLVED] Getting rid of update links popup?
    By Scott buckwalter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2005, 08:05 PM
  5. [SOLVED] Can't break a link, all links are removed
    By Peter F in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-10-2005, 11:06 AM

Tags for this Thread

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