software

Is there a way to view cells containing data that is linked to cells in
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

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

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] amp; if no window pops up there are no
external links.

To see which cells contain formulae:
[F5], Special, Formulas (amp; 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 quot;sheetquot;
is probably linking to another worksheet.

hth
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=534519Bill Manville's FindLink program:
www.oaltd.co.uk/MVP/Default.htm

Patsy Rogge wrote:
gt;
gt; Hi you need to download a file (addin) called Find Links. You will be able
gt; to find it if you do a Google search
gt;
gt; Patsy
gt;
gt; quot;TKC!quot; gt; wrote in message
gt; ...
gt; gt; Is there a way to view cells containing data that is linked to cells in
gt; gt; another worksheet in Excell?
gt; gt;

--

Dave Peterson