Series referencing a document that I have no access to

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/
_______
 
Thanks Jon. I'll check it out!

Jon Peltier said:
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/
_______
Click to expand...
 
Back
Top