Finding cells with links to another worksheet in excell
 

Is there a way to view cells containing data that is linked to cells in
another worksheet in Excell?

Finding cells with links to another worksheet in excell
 

Hi you need to download a file (addin) called Find Links. You will be able
to find it if you do a Google search

Patsy


"TKC!" wrote in message
...
Is there a way to view cells containing data that is linked to cells in
another worksheet in Excell?

Finding cells with links to another worksheet in excell
 

hi TKC,
I'm not sure if I understand correctly what you are after, but the
following may help...

(Please excuse my use of short cut keys)

To quickly see if there are any external links (ie another
workbook/file) use [alt + e + k] & if no window pops up there are no
external links.

To see which cells contain formulae:
[F5], Special, Formulas (& tick the types you want to check)
or
[ctrl + `] (found at top left of my keyboard)
or
[alt + t + o], and then tick the Formulas box in the Windows Options
section at the bottom of the View tab.

The last 2 options change the view so that you see the actual formulae
rather than the result. Any formula where you can see the word "sheet"
is probably linking to another worksheet.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=534519

Finding cells with links to another worksheet in excell
 

Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Patsy Rogge wrote:

Hi you need to download a file (addin) called Find Links. You will be able
to find it if you do a Google search

Patsy

"TKC!" wrote in message
...
Is there a way to view cells containing data that is linked to cells in
another worksheet in Excell?


--

Dave Peterson