 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007Can 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. *** Look here: http://www.dailydoseofexcel.com/archives/2007/10/11/beta-testing-request/  SignatureKind 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. [quoted text clipped - 11 lines] | | *** 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>. SignatureHTH, 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. *** RagDyeR: God DAMN it, that's good. I should've discovered that intuitively Thanks much to both you and Niek for replies. *** 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> SignatureRegards, 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. *** |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.