Excel - Find external links
Excel - Find external links
(OP)
I've got a spreadsheet that upon opening says contains links to other data sources. I don't remember ever linking to other data sources though.
Does anyone know of a way to locate cells that may have such a link. The spreadsheet has 3 tabs each containing many cells of calculations so clicking thru each will be TEDIOUS.
Does anyone know of a way to locate cells that may have such a link. The spreadsheet has 3 tabs each containing many cells of calculations so clicking thru each will be TEDIOUS.





RE: Excel - Find external links
If I remember correctly, you had to view the the links before performing any other actions. Meaning, when you first opened the file, you could view the links but if you have been working in the file already, you lose the ability. So save your work and open it again.
The other thing you could do is do a find/replace. Find one link and then copy the destination and search for it throughout the file.
Replace is one of the greatest functions in Excel if you ask me.
RE: Excel - Find external links
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
RE: Excel - Find external links
RE: Excel - Find external links
I found a couple options from the help menu too, but none worked. I tried searching for [ and .xls in formulas, tried some Edit-GoTo-Special, but no luck.
The spreadsheet seems to work, it's just odd and annoying.
RE: Excel - Find external links
RE: Excel - Find external links
I've double checked everything works. I've even opened it on a different machine off the network and it still works. Who knows?!
Thank you all for spending a few minutes thinking about it though.
RE: Excel - Find external links
ht
-AK2DM
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"It's the questions that drive us"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
RE: Excel - Find external links