EXCEL - Auditing - TRACE to show source from another page
 

When using the Auditing feature, one can only trace backwards to source cells
on the same page.
Proposal, if the source cell is on another page, show the cell ID. If the
source cell is visible in another window, have it highlighted also.

T0-TRACE should work in the same manner.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Why do you say that you can't go forward and backward when auditing, when
the cells are on different pages?

The criteria for tracing forward and backward is *not* the cell location.
The criteria is that the cell location is situated in an *open* WB.

Of course, this is a moot point if the cells are on different sheets in the
same WB.

Check out this old post to see how you can go back and forth with your
auditing.

http://tinyurl.com/agl8n


--
HTH,

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


"Tuba Joe" <Tuba wrote in message
...
When using the Auditing feature, one can only trace backwards to source
cells
on the same page.
Proposal, if the source cell is on another page, show the cell ID. If the
source cell is visible in another window, have it highlighted also.

T0-TRACE should work in the same manner.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...et.f unctions