Finding Links in a large spreadsheet
 

I'm feeling lazy!
Anybody out there got an add-in, or the code for an add-in that will
identify all links within a spreadsheet to external file?

The situation I have is that a really large file that I use has
suddenly started to ask me, on opening up the file, if I'd like to
update links? To the best of my knowledge there aren't any links!

How do I find where they are hiding to get rid of them?

Any help greatly appreciated.
Jason Quirk

Finding Links in a large spreadsheet
 

Jase,
With spreadsheet in question open go to EDITLINKS. That will be a good
place to start.
If you need a little more horsepower there is a utility that has the
ability to audit workbook links at
http://j-walk.com/ss/pup/pup6/index.htm
and check out PUPv6 utility from j-walk and assoc.


HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=493532

Finding Links in a large spreadsheet
 

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

jase wrote:

I'm feeling lazy!
Anybody out there got an add-in, or the code for an add-in that will
identify all links within a spreadsheet to external file?

The situation I have is that a really large file that I use has
suddenly started to ask me, on opening up the file, if I'd like to
update links? To the best of my knowledge there aren't any links!

How do I find where they are hiding to get rid of them?

Any help greatly appreciated.
Jason Quirk

--

Dave Peterson

Finding Links in a large spreadsheet
 

Try this link. You want the findlink addin...

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

Jim Thomlinson


"jase" wrote:

I'm feeling lazy!
Anybody out there got an add-in, or the code for an add-in that will
identify all links within a spreadsheet to external file?

The situation I have is that a really large file that I use has
suddenly started to ask me, on opening up the file, if I'd like to
update links? To the best of my knowledge there aren't any links!

How do I find where they are hiding to get rid of them?

Any help greatly appreciated.
Jason Quirk