+ Reply to Thread
Results 1 to 14 of 14

Hidden links? How to get rid of?

Hybrid View

Sebastian_S Hidden links? How to get rid... 03-06-2014, 06:35 AM
:) Sixthsense :) Re: Hidden links? How to get... 03-06-2014, 06:44 AM
Sebastian_S Re: Hidden links? How to get... 03-06-2014, 06:55 AM
:) Sixthsense :) Re: Hidden links? How to get... 03-06-2014, 07:04 AM
Sebastian_S Re: Hidden links? How to get... 03-06-2014, 07:23 AM
Izandol Re: Hidden links? How to get... 03-11-2014, 05:05 AM
Sebastian_S Re: Hidden links? How to get... 03-17-2014, 09:32 AM
adyteo Re: Hidden links? How to get... 03-11-2014, 06:23 AM
Izandol Re: Hidden links? How to get... 03-17-2014, 09:59 AM
Sebastian_S Re: Hidden links? How to get... 03-20-2014, 05:16 AM
  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    7

    Hidden links? How to get rid of?

    Welcome.
    The attached file contains probably some hidden links that appear only in August when we do even one "normal" link to another file. I tried with a macro that shows all of the links it contains the file, but it still does not show me the problem. I also attach screenshots that show an attempt to connect to external files (hidden links). I do not know how to remove them. Has anyone an idea what it could be and how to get rid of?

    When you open the excel file, press update, after a long pause jump out messages about trying to connect to an external file. What is it and how to remove?

    Thanks in advance...
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Hidden links? How to get rid of?

    Check D11 cell for external link reference.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    03-06-2014
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Hidden links? How to get rid of?

    Yes, I know about this link. I did it on purpose, as a link to just any file to Detect the problem. If I delete the link, disappears also request to external files, servers. But this does not solve the problem.

    Then just re-do it no matter what link, even up to a blank file and the problem re-appears.
    Last edited by Sebastian_S; 03-06-2014 at 06:57 AM.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Hidden links? How to get rid of?

    Press Alt+E+K>>Click Startup Prompt>>Select Don't Display the alert and update links....>>Give Ok...

    Save and close the file.

    Re-open the file and check

  5. #5
    Registered User
    Join Date
    03-06-2014
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Hidden links? How to get rid of?

    Thanks, but this is not a solution, just hiding the problem. Besides the attached file is just an example. Normally I have files, and even dozens of links that I have to update. Ok I can do it as you write and then update a selected link, but it does not solve the problem.

    I would like to find a solution that despite the need to update the file the "weird / hidden" links not loaded. Just remove the links, from the file.

    PS. The problem appeared after moving from Excel 2003 to 2010 in some files. I suspect that someone once did file, which later spread to form on the basis of other, unfortunately, we have some of these files;/

    PS2. If I write something not understandable, I'm sorry for my english :D
    Last edited by Sebastian_S; 03-06-2014 at 07:27 AM.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Hidden links? How to get rid of?

    Check whether this helps you...

    Press Alt+T+O>>Trust Center>>Trust Center Setting>>External Content>>Check those settings.

  7. #7
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Hidden links? How to get rid of?

    There are many (110) hidden names in this file. Please run this code:
    Sub unhideNames()
       Dim nm As Name
       For Each nm In ActiveWorkbook.Names
          nm.Visible = True
       Next nm
    End Sub
    then examine results in Name Manager on Formulas tab.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  8. #8
    Registered User
    Join Date
    03-06-2014
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Hidden links? How to get rid of?

    Quote Originally Posted by Izandol View Post
    There are many (110) hidden names in this file. Please run this code:
    Sub unhideNames()
       Dim nm As Name
       For Each nm In ActiveWorkbook.Names
          nm.Visible = True
       Next nm
    End Sub
    then examine results in Name Manager on Formulas tab.
    YES Thank you for solving the problem :D finally got rid of that, thanks to you. Earlier I tried to remove the name using code:

    Dim n As Name
    On Error Resume Next
    For Each n In ActiveWorkbook.Names
    n.Delete
    Next n


    But it did not give the expected result.

    Can I have an additional question. How should look macro code that immediately unhidden and delete names without manual interference with the manager names.

  9. #9
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: Hidden links? How to get rid of?

    Maybe I miss the point but I downloaded the file, I broke the link, saved the file and when I re-opened there was no link (see it attached).
    Attachment 303523

    Did I miss something? What do I need to do to see all the hidden links?
    Click on the star if you think I helped you

  10. #10
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Hidden links? How to get rid of?

    When names become corrupt sometimes they must be removed manually.

  11. #11
    Registered User
    Join Date
    03-06-2014
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Hidden links? How to get rid of?

    Sub unhideNames()
    Dim nm As Name
    For Each nm In ActiveWorkbook.Names
    nm.Visible = True
    Next nm

    On Error Resume Next
    For Each nm In ActiveWorkbook.Names
    nm.Delete
    Next nm

    End Sub


    and works

+ 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. Updating Hidden Links?
    By basils57 in forum Excel General
    Replies: 2
    Last Post: 02-28-2013, 06:19 AM
  2. Macro to find and replace links in hidden worksheets
    By lottidotti in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-09-2013, 09:45 PM
  3. Removing Hidden Links
    By Dulanic in forum Excel General
    Replies: 6
    Last Post: 11-06-2012, 10:16 PM
  4. [SOLVED] Removing "hidden" ODBC links
    By Richard Edwards in forum Excel General
    Replies: 1
    Last Post: 02-01-2006, 11:30 AM
  5. Removing "hidden" ODBC links
    By Richard Edwards in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2006, 11:30 AM

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