+ Reply to Thread
Results 1 to 2 of 2

Identify external workbooks that access my data

  1. #1
    Forum Contributor
    Join Date
    10-16-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003, 2010
    Posts
    151

    Identify external workbooks that access my data

    Greetings all!

    I have a problem that I hope someone can help me with. I have a workbook containing product data, basically a flat file database. The workbook resides on the company server and other workbooks reference this one for all kinds of snippets of data. I don't have a list of all of the external files that use this product data file, and I have just been informed that IT wants to compartmentalize our server to limit access and protect against viral data attacks.

    The thing I have been tasked with is to locate all of the external files using this product data file so that I can update the formulas to point them back to this file when they start making changes to the server. I know I can track back to the product data file from any file that uses it, but is there any way to do the reverse and see all of the files that access this one?

    Any help would be appreciated!

    Jake
    Last edited by jacob@thepenpoint; 02-08-2016 at 11:36 AM.
    Jacob Albers
    Excel 2003 & 2010

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,177

    Re: Identify external workbooks that access my data

    no, there is no link internally in the excel file to detect this.
    youd have to scan all the external files for a path to the excel file.

+ 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] Linking External Data From Access to Excel
    By DLee-AB in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-01-2015, 12:04 PM
  2. Find and identify duplicate data across multiple workbooks
    By raw_geek in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-23-2013, 02:27 PM
  3. Replies: 5
    Last Post: 01-19-2011, 08:30 PM
  4. [external data] Two queries same access files...
    By El_Pablo in forum Excel General
    Replies: 0
    Last Post: 10-31-2008, 03:04 PM
  5. [SOLVED] MONTHNAME when getting external data from Access
    By -PJ in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2006, 03:55 PM
  6. [SOLVED] Get external data from MS Access using variables
    By RTP in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-10-2006, 10:25 PM
  7. [SOLVED] Getting external data from Access to Excel
    By Veli Izzet in forum Excel General
    Replies: 6
    Last Post: 07-22-2005, 12:05 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