Can Formula Auditing give cell refs to other sheets?

[baobob]

You gotta admit, Excel 2002 10.2614.2625's Formula Auditing is the
greatest thing since, well, the reintroduction of unsliced bread.

However, I have workbooks with dozens of sheets.

For references on other sheets, all Tools / Formula Auditing does is
give you a little arrow and sheet token by way of telling you that
there IS one or more references, period. Which is totally useless.

Isn't there a dialog Excel can launch to list a cell's actual
antecedents and dependencies on other sheets?

Thanks much.

***

 

[Niek Otten]

Look here:

http://www.dailydoseofexcel.com/archives/2007/10/11/beta-testing-request/

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| You gotta admit, Excel 2002 10.2614.2625's Formula Auditing is the
| greatest thing since, well, the reintroduction of unsliced bread.
|
| However, I have workbooks with dozens of sheets.
|
| For references on other sheets, all Tools / Formula Auditing does is
| give you a little arrow and sheet token by way of telling you that
| there IS one or more references, period. Which is totally useless.
|
| Isn't there a dialog Excel can launch to list a cell's actual
| antecedents and dependencies on other sheets?
|
| Thanks much.
|
| ***
|

 

[RagDyeR]

What you have to do to access off-sheet precedents is:

Hover your cursor around the dotted line that's between the cell and the
sheet icon until the cursor changes to an arrow,
... THEN *double click*.

This opens the familiar "Go To" window,
where the off-sheet addresses are listed in the Go To box.

Click on the one (if more then 1 are listed) you're interested in,
And hit <Enter>.

--

HTH,

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


You gotta admit, Excel 2002 10.2614.2625's Formula Auditing is the
greatest thing since, well, the reintroduction of unsliced bread.

However, I have workbooks with dozens of sheets.

For references on other sheets, all Tools / Formula Auditing does is
give you a little arrow and sheet token by way of telling you that
there IS one or more references, period. Which is totally useless.

Isn't there a dialog Excel can launch to list a cell's actual
antecedents and dependencies on other sheets?

Thanks much.

***

 

[baobob]

RagDyeR:

God DAMN it, that's good. I should've discovered that intuitively

Thanks much to both you and Niek for replies.

***

 

[RagDyeR]

You're welcome, and thank you for the feed-back,
*BUT*
I must disagree with you!

I don't think that MS designed *anything intuitive* into this feature.

Why would they program the feature to activate with a double click on the
dotted line, instead of the sheet icon?

That's pretty much *counter-intuitive* to me.<g>
--

Regards,

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


RagDyeR:

God DAMN it, that's good. I should've discovered that intuitively

Thanks much to both you and Niek for replies.

***