+ Reply to Thread
Results 1 to 3 of 3

Series referencing a document that I have no access to

  1. #1
    Barb Reinhardt
    Guest

    Series referencing a document that I have no access to

    I have an Excel workbook with charts that reference a document that I do not
    have access to. How do I find each and every instance of those references?

    Thanks in advance,
    Barb Reinhardt

  2. #2
    Jon Peltier
    Guest

    Re: Series referencing a document that I have no access to

    Bill Manville wrote an add-in called FindLink.xla, which I believe is
    available on Stephen Bullen's web site, http://oaltd.co.uk. I don't know
    if it specifically finds links to missing files, but it finds external
    links. When you find a link to an inaccessible workbook or network path,
    you can do a search for selective text strings extracted from the link
    to find more.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______


    Barb Reinhardt wrote:

    > I have an Excel workbook with charts that reference a document that I do not
    > have access to. How do I find each and every instance of those references?
    >
    > Thanks in advance,
    > Barb Reinhardt


  3. #3
    Barb Reinhardt
    Guest

    Re: Series referencing a document that I have no access to

    Thanks Jon. I'll check it out!

    "Jon Peltier" wrote:

    > Bill Manville wrote an add-in called FindLink.xla, which I believe is
    > available on Stephen Bullen's web site, http://oaltd.co.uk. I don't know
    > if it specifically finds links to missing files, but it finds external
    > links. When you find a link to an inaccessible workbook or network path,
    > you can do a search for selective text strings extracted from the link
    > to find more.
    >
    > - Jon
    > -------
    > Jon Peltier, Microsoft Excel MVP
    > Peltier Technical Services
    > Tutorials and Custom Solutions
    > http://PeltierTech.com/
    > _______
    >
    >
    > Barb Reinhardt wrote:
    >
    > > I have an Excel workbook with charts that reference a document that I do not
    > > have access to. How do I find each and every instance of those references?
    > >
    > > Thanks in advance,
    > > Barb Reinhardt

    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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