Can Formula Auditing give cell refs to other sheets?
 

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.

***

Can Formula Auditing give cell refs to other sheets?
 

Look he

http://www.dailydoseofexcel.com/arch...sting-request/

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ups.com...
| 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.
|
| ***
|

Can Formula Auditing give cell refs to other sheets?
 

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!
================================================== ===


wrote in message
ups.com...
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.

***

Can Formula Auditing give cell refs to other sheets?
 

RagDyeR:

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

Thanks much to both you and Niek for replies.

***

Can Formula Auditing give cell refs to other sheets?
 

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 !
-----------------------------------------------------------------------------------------------


wrote in message
ups.com...
RagDyeR:

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

Thanks much to both you and Niek for replies.

***