Use Go to function to identify dependent cells between worksheets

[Guest]

I have a workbook with several spreadsheets. There are cells in one
spreadsheet containnig formulae that use data entered in cells located both
in the same spreadsheet and in other spreadsheets. I use the "go to" function
to identify the prescendent cells in the worksheet but I can not trace the
prescendent cells which are in other worksheets.

What I want to do is find those cells that input data and check that the
data I have input are correct. Is there any way I can do this?

Thank you

 

[RagDyeR]

Select the cell containing the formula, then:

<Tools> <Formula Auditing> <Trace Precedents>

This should give you a display of blue arrows tracing the cells in the
current sheet.
You should *also see* a black dotted line ending in a small sheet icon.

Hover the cursor over this dotted line until it changes to an arrow ... then
*Double* click!

This will bring up the familiar "Go To" window, with the *off sheet*
precedent cells listed in the big "Go To" window.
*Double* clicking on any cell in that window will switch your screen display
to that particular cell.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have a workbook with several spreadsheets. There are cells in one
spreadsheet containnig formulae that use data entered in cells located both
in the same spreadsheet and in other spreadsheets. I use the "go to"
function
to identify the prescendent cells in the worksheet but I can not trace the
prescendent cells which are in other worksheets.

What I want to do is find those cells that input data and check that the
data I have input are correct. Is there any way I can do this?

Thank you

 

[Peo Sjoblom]

You cannot use go to directly to go to precedents in other workbooks,
however you can get there, do tools>formula auditing, trace precedents, for
other sheets or other workbooks you will get a dotted line with a
spreadsheet icon, double click that line and it will bring up the go to
dialogue box with the address to the sheet/workbook there, double click the
link in the go to box and you will go there. Of course it will not work if
the linked workbook is closed.