How to trace dependents across worksheets?

How can I trace dependents across worksheets?

Suppose I have a cell with the name Foo in Sheet2,
and I reference Foo in Sheet1.

When I go to Sheet2 and select Trace Dependents
under Tools / Formula Auditing), Excel shows an
arrow to an icon that resembles a spreadsheet.
But I have not found a way to expand the icon
into a cell reference or even to identify the
worksheet. Moreover, if I visit each worksheet,
I do not automatically see off-sheet arrows to
those dependent cells.

(Note: Show All is selected under Tools / Options /
View. I am using Excel 2003 rev 11.6355.6360 SP1
with Win XP Pro SP2.)

Approach the leader to the icon and the cursor will turn into an
arrow..........then double-click, a window will pop-up identifying the
source.......(XL2k)

Vaya con Dios,
Chuck, CABGx3


<[email protected]> wrote in message
news:[email protected]...
> How can I trace dependents across worksheets?
>
> Suppose I have a cell with the name Foo in Sheet2,
> and I reference Foo in Sheet1.
>
> When I go to Sheet2 and select Trace Dependents
> under Tools / Formula Auditing), Excel shows an
> arrow to an icon that resembles a spreadsheet.
> But I have not found a way to expand the icon
> into a cell reference or even to identify the
> worksheet. Moreover, if I visit each worksheet,
> I do not automatically see off-sheet arrows to
> those dependent cells.
>
> (Note: Show All is selected under Tools / Options /
> View. I am using Excel 2003 rev 11.6355.6360 SP1
> with Win XP Pro SP2.)
>

CLR wrote:
> Approach the leader to the icon and the cursor will turn into an
> arrow..........then double-click, a window will pop-up identifying
> the source.......(XL2k)

Bingo! Thanks. My inclination was to try the above when
putting the cursor on the spreadsheet icon. I had not
thought of double-clicking on the arrow. Thanks again.

An old one, but a good tip - a belated thanks for solving my frustrations

On a side note, I don't really see the point in having the little worksheet icon if it doesn't do anything!!!