+ Reply to Thread
Results 1 to 4 of 4

Cannot find "Edit Links" external reference

  1. #1
    Registered User
    Join Date
    05-02-2005
    Posts
    65

    Cannot find "Edit Links" external reference

    I am running Excel 2016 and I have re-designed the attached worksheet. The original had references to an external file but the current one should not. When you hit the "Edit Links" option on the Data Tab, it shows the external link. However, I cannot find that link so that I can fix it. Based on reading the Excel Help and other posts, I searched:
    * cell formulas;
    * defined names (there is only one in Name Manager); and
    * Data Validation (there are multiple columns that have data validation).

    I have spent far too much time on this and I would greatly appreciate if you can point me in the right direction. It is probably something simple but I cannot find it!

    On a related note, it seems since upgrading from Excel 2013, when using data validation, I notice that when the validation is pulling from another tab, it defines it with the TAB Name along with absolute reference (e.g. =Prefs!$a$1:$a$5). On numerous occasions, after defining it and using it for some time, Excel seems to lose the TAB name and it only has the Absolute reference without the TAB Name so it assumes that it is current TAB. I thought that this might be a cause of the problem. Was there a change to 2016 (versus 2013) in this regard or, again, I am doing something wrong?

    Thanks you, in advance, for your time and guidance!
    Jim
    Attached Files Attached Files
    Last edited by jshrader; 07-25-2017 at 01:27 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Cannot find "Edit Links" external reference

    Hey Jim,

    Try the Data Tab and then "Get Data" and then "Data Source Settings" in the dropdown. Is that where it moved?

    If not - was your source in a Power Query? Were you in Edit move of a PQ?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    05-02-2005
    Posts
    65

    Re: Cannot find "Edit Links" external reference

    Hello MarvinP! Thank you for your response. To answer your questions:
    1)Data Tab >> Get Data >> Data Source Settings give me the response "We didn't find any data sources in this workbook."
    2) Was this a PQ? I do not have the PQ module installed. The source solution is made up of 2 workbooks (one for allowed options and the 2nd for the sales rep's selection) stored in the same local folder. Those files were pulled to a network folder for later distribution to multiple users and stored in the same local folder names. The files were then changed on the network drive that then unfortunately changed the links to the network folder instead of the local folder. When they were copied down to the local folder the system did not work since those PC's did not have access to the network folder. I then pieced it together what happened so I took the local workbook and attempted to change all network file links. I was able to determine that the tab that I attached was the guilty party because as soon as I deleted that TAB, the Edit Links button grayed out. I cannot find out where that last link is.

    I hope I not confusing you too much. Let me know if you need additional details.

    Thanks again for your time and consideration!!
    Jim

  4. #4
    Registered User
    Join Date
    05-02-2005
    Posts
    65

    Re: Cannot find "Edit Links" external reference

    I have been traveling the past couple of days, but when I cam back an opened up the spreadsheet, it no longer ad any external links. I am not sure what solved the problem, but eh only things that I did was the checks that MarvinP asked. Thanks!

+ 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. Replies: 24
    Last Post: 03-21-2022, 08:01 AM
  2. "Manual" option grayed out in Edit Links window
    By JayUSA in forum Excel General
    Replies: 4
    Last Post: 07-07-2015, 05:21 AM
  3. Replies: 14
    Last Post: 12-27-2014, 11:43 AM
  4. Replies: 3
    Last Post: 04-08-2014, 08:54 AM
  5. After Updating Links the Edit Box Opens, but all links are "OK"???
    By FLSnuffy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-06-2012, 07:47 AM
  6. Replies: 0
    Last Post: 12-07-2008, 01:25 PM
  7. Excel: Finding external "links" in a spreasheet
    By CILeader in forum Excel General
    Replies: 3
    Last Post: 10-15-2005, 02:05 PM
  8. [SOLVED] Excel 2003: Temporarily "turning off" links to external files...
    By Birmangirl in forum Excel General
    Replies: 1
    Last Post: 08-19-2005, 10:05 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