Find External Links

[Guest]

I have a spreadsheet someone else created. Upon opening, it asks what I wish
to do about external references. Here is what I want to do: I want to find
them. I can go to edit links and see that there are links, but how can I
find the cells that contain the links? Then I can make intelligent decisions
about what to do about them. Thanks....

 

[JP]

You may have to go through every formula in the workbook to find
links.

Hit Ctrl-G, choose 'Special' and select 'Formulas'.

Then just hit Enter to cycle through all the formulas until you find
it.


HTH,
JP

 

[Guest]

There is a great tool for finding links call FindLinks.zip

http://www.oaltd.co.uk/MVP/

 

[JP]

Good point, you could just Ctrl-F and search for "xls" it jumps right
to the link (assuming it's an XL file).


Thx,
JP

 

[Dave Peterson]

But those links can hide in places that ctrl-f won't search--like names and
charts and ...

 

[JP]

Looks like I'll be using that tool as well. Thanks Dave.

--JP

 

[Thomas]

This is a great add-in...I saved the download to my AddIns folder but cannot
seem to activate it in Excel from Tools...I noticed it had a .xla
extension...any tips for getting it to work? am I missing a step maybe?

I downloaded and used it with no problems on my old laptop but cant get it
to work with my new laptop...an updated version maybe?

Im a 2003 user...

thanks!