Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941

    Unanswered: Linked workbooks

    I pretty sure this isn't possible, but it can't hurt to ask.

    If a have a workbook that I populate from SQL Server every night with some business critical data. The file is in a location where people can link to it. I've been asked to add mucho info to it over the past few years, and I've lost track of who links to it and why. I'd like to audit the file to remove lines that aren't used. Is there any way to find the files that are linked to this one?
    Inspiration Through Fermentation

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    In Excel Help, type the word "link" in the Index tab. You should find something usable in the result topic window.

    HTH,
    Sam

  3. #3
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Found this at microsoft.com

    Make links easy to track There's no automatic way to find all the cells in a workbook that contain links. ...
    That applies to the linked workbook. That's why I think they didn't bother doing anything for a source workbook.
    Inspiration Through Fermentation

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    You might try the add-in: Findlink by Bill Manville (hosted on site by Stephen Bullen).
    Last edited by shades; 07-25-07 at 15:12.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Feb 2004
    Posts
    533
    My first thought was to change the name of the file, then wait for the phone to ring when your users can no longer find or connect to it

    You may want to try some of the other suggestions first.
    ~

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •