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

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

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