+ Reply to Thread
Results 1 to 3 of 3

Hidden links in workbook from nowhere

  1. #1
    Registered User
    Join Date
    09-21-2020
    Location
    RuoyTon
    MS-Off Ver
    2013
    Posts
    1

    Hidden links in workbook from nowhere

    Thank you for taking a look.

    I have a pretty simple file now that was built on a basis of an old complex file with a lot of links. In this testing file, Alpha (PF recast 11 09_f.xlsm in attachments) there is only 1 value, which refers via formula to 1 value of another workbook. The second workbook (Beta) (Book1 in attachments) is completely new, and can be any book you can create. I just added there one value.

    Issue: when I'm opening workbook Alpha, I have a lot of popups that appear after the button in "Update links" window was clicked, or when I trigger "Enable Content". Popups like this (screenshots in attachments) with links to other strange old workbooks and with old paths. I can't understand where should I start searching for reasons of this if I already broke all links in the workbook Alpha, which were there, cleaned up all macro were contained, and have only one link to a fresh workbook Beta (which have no connection with links you can see in popups).
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: Hidden links in workbook from nowhere

    I can open the first file without enabling macros or links. I can then go straight to Data | Edit links, select the link to Book1 and Break the link. Save As, Close and Re-open, links gone.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: Hidden links in workbook from nowhere

    Note 1: although it is an .xlsm file, there are no macros in it

    Note 2: most of the Named Formulas have #Ref! errors

    Not sure if either of those points is relevnt

+ 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. Breaking Hidden Links
    By dflak in forum Tips and Tutorials
    Replies: 2
    Last Post: 10-09-2017, 03:27 PM
  2. [SOLVED] Workbook links causing linked workbook to open, but remain hidden
    By Rob T in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2014, 06:24 AM
  3. Hidden links? How to get rid of?
    By Sebastian_S in forum Excel General
    Replies: 13
    Last Post: 03-20-2014, 05:16 AM
  4. Updating Hidden Links?
    By basils57 in forum Excel General
    Replies: 2
    Last Post: 02-28-2013, 06:19 AM
  5. Removing Hidden Links
    By Dulanic in forum Excel General
    Replies: 6
    Last Post: 11-06-2012, 10:16 PM
  6. VBA Function Vlookup data from Hidden sheet in hidden workbook
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2008, 11:22 PM
  7. Hidden columns NOT HIDDEN on shared workbook
    By Excel Kurt in forum Excel General
    Replies: 2
    Last Post: 07-11-2007, 03:16 PM

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