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
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks