+ Reply to Thread
Results 1 to 4 of 4

Cannot find linked workbooks found via Workbook Analysis (Inquire tab)

  1. #1
    Registered User
    Join Date
    01-02-2018
    Location
    Utah
    MS-Off Ver
    2013
    Posts
    2

    Question Cannot find linked workbooks found via Workbook Analysis (Inquire tab)

    Hello,

    There are two workbook links that are hidden in my Excel 2013 Excel file. I believe they are causing Excel to crash as they try to access a network folder I don't have access to. The only way I know the links exist is through the Inquire tab, using the Workbook Analysis tool (see screenshot below). The problem is that Workbook Analysis doesn't tell me the location of the links so I don't know how to remove them. I have tried the following:searched in Name Manager (don't have any named ranges listed there), reviewed all conditional formatting (don't see any references to external files), used CTRL+F in formulas for "[", ".xl" (no luck), opened Workbook Connections window in the Data tab (no connections visible), tried to

    Thank you very much for your assistance.

    workbook analysis snip.PNG

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Cannot find linked workbooks found via Workbook Analysis (Inquire tab)

    check:
    • conditional formatting
    • data validation
    • name manager
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    01-02-2018
    Location
    Utah
    MS-Off Ver
    2013
    Posts
    2

    Re: Cannot find linked workbooks found via Workbook Analysis (Inquire tab)

    No luck. I checked conditional formatting in all worksheets as well as data validation, but nothing I can find references another workbook. Name Manager shows there are no named ranges in the workbook... Any other ideas?

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Cannot find linked workbooks found via Workbook Analysis (Inquire tab)

    Quote Originally Posted by ExcelHomie View Post
    Any other ideas?
    Yes, attach this workboook

+ 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: 2
    Last Post: 06-20-2012, 09:08 PM
  2. Linked workbooks without opening the workbook
    By NyoGoat in forum Excel General
    Replies: 4
    Last Post: 05-03-2012, 05:19 AM
  3. When updating linked info from external workbook why does it say file not found?
    By monkdelafunk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-11-2008, 04:37 AM
  4. Find which cell is linked to another workbook
    By Pat van Aalst in forum Excel General
    Replies: 3
    Last Post: 03-03-2006, 09:10 AM
  5. Replies: 1
    Last Post: 11-10-2005, 09:10 AM
  6. keeping links active between workbooks when a user moves linked workbook
    By bodem96 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-28-2005, 06:57 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