+ Reply to Thread
Results 1 to 4 of 4

Locate a reference to another workbook in excel

  1. #1
    Registered User
    Join Date
    05-26-2015
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    28

    Locate a reference to another workbook in excel

    Hello,
    When i check my links (file -> Edit links to files)
    i get a list of all the excel sheets to which my current workbook has references too.
    One of the references is named:

    "Dækberegning_bæreevne_check.xlsx"

    How do i find the location of this reference, i.e which cell in my current workbook actually has a reference to that workbook?

    I tried doing a regular search in workbook for the name of the workbook, with no luck.

  2. #2
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Locate a reference to another workbook in excel

    Hope this link will solve your issue....
    HTML Code: 
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!

  3. #3
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Locate a reference to another workbook in excel

    It might be hidden in a few other places. I would recommend searching through the following:
    1) Check your named ranges (Formulas --> Name Manager).
    2) Check your charts
    3) Check any objects or shapes that may have a Macro assigned to it (Macro may be referring to a macro from another workbook i.e. external reference)
    4) The most painful of all, Data Validation. I hope you don't have to go here because you would have to locate all data validation and check their settings. Handy tip, select an empty cell on the sheet you want to find the data validation. Press F5, Special Cells, select Data Validation, All.

  4. #4
    Registered User
    Join Date
    05-26-2015
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    28

    Re: Locate a reference to another workbook in excel

    The problem is that the Excel workbook is a huge sheet, with tons of hidden sheets, cells rows and a ton of macros, meaning it will take me forever to try and locate where the broken link might be. I had hoped there could be a one click solution but i guess not.

    But thanks for the help, it's nice to know where i can look if need be.

+ 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. VBA help needed to locate the excel workbook then import data into a table
    By krjoshi in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 09:33 AM
  2. Locate Data across multiple sheets in an Excel Workbook
    By Gorbs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2014, 10:46 AM
  3. cell reference to locate/ store data in excel vb macro
    By cvsuryam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-21-2011, 12:16 PM
  4. [SOLVED] Excel 2003 hangs when trying to locate a workbook to open
    By Darren Hill via OfficeKB.com in forum Excel General
    Replies: 1
    Last Post: 03-24-2005, 09:06 AM
  5. Replies: 2
    Last Post: 02-02-2005, 10:06 PM

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