+ Reply to Thread
Results 1 to 3 of 3

Data from External Source

  1. #1
    Forum Contributor
    Join Date
    12-02-2014
    Location
    England
    MS-Off Ver
    2010 | 2016
    Posts
    167

    Data from External Source

    Hi,

    I've been developing an automated milestone tracker for the past couple of months and the office I work in has just converted to Office 10.

    Consequently every time I open my sheet I find it asking me if I want to update the data in my sheet.

    I have never linked to another sheet and have tried doing the Find & Select for the "[" or "]" and it pulls nothing up.

    Any ideas?

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    01-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    240

    Re: Data from External Source

    This is normally named ranges - check in the named range manager and I am sure you'll find some named ranges referencing external ranges. This normally unintentially happens when copying sheets between workbooks.
    Please consider adding a * if I helped.

  3. #3
    Forum Contributor
    Join Date
    01-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    240

    Re: Data from External Source

    You could have hidden names ... run this to make them visible.....


    Please Login or Register  to view this content.

+ 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. Getting data from external source by date
    By MDNerey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 05:43 PM
  2. Graphs with external source data
    By shabbalabba in forum Excel General
    Replies: 1
    Last Post: 07-07-2010, 06:17 AM
  3. Getting data from external csv source
    By ajocius1 in forum Excel General
    Replies: 1
    Last Post: 07-18-2008, 10:52 AM
  4. external data source security
    By jsy in forum Excel General
    Replies: 4
    Last Post: 11-24-2006, 04:44 AM
  5. External Data Source
    By S Walker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2005, 12:45 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