+ Reply to Thread
Results 1 to 3 of 3

Finding a faulty data source

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Finding a faulty data source

    I am working at home using Dell SonicWall netextender to connect to our main server.
    When I open the developing app I get the warning:-
    "This workbook contains links to external sources" I press Continue and proceed.
    At a later stage in the app I get the message :-

    "We cant update some of the links right now" I press edit and I see that there is what looks like a garbled Range name from the app.
    I cant find this garbled name in any of my code and it is not in the list of named ranges. I would like to find it and remove . Is there another way of discovering its whereabouts?
    John

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Finding a faulty data source

    Search through formulas, data validation, chart sources and conditional formatting rules. I'd recommend Bill Manville's FindLink add-in to save time.
    Rory

  3. #3
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: Finding a faulty data source

    Thanks for your advice. I searched through all the worksheets and found the offending text was a garbled row heading used in an INDEX/MATCH lookup.
    John

+ 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. [SOLVED] Complex data analysis, finding values from one main source
    By Eduards in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-25-2019, 10:26 AM
  2. Question in Finding a Value Within a Set Between Two Data Source
    By JasonAhn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-09-2015, 06:56 AM
  3. Web Query Faulty Data Return on CreateObject("X") AND .Send
    By dogman6126 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2015, 04:26 AM
  4. Replies: 2
    Last Post: 05-12-2015, 03:46 PM
  5. Help with finding source of formula data
    By ubelongoutside in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-22-2015, 06:07 PM
  6. [SOLVED] finding source data
    By piperhammy in forum Excel General
    Replies: 3
    Last Post: 12-13-2012, 05:29 PM
  7. Issue with finding data source using CurDir
    By Arsi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2011, 03:15 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