 |
 | 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 / April 2008Trace Precedents /dependents in another sheet
Dear Experts Im using Excel 2007 Im attempting to audit a sheet where the formula are in one sheet and the totals are in another. When using either the Trace Precedents or dependents function , all I get is an arrow pointing to a worksheet icon without any info on the cell ref of the formula or the dependent (depending on which way I run it) Is there any way of getting this info if the data is on two separate sheets or files. Thanks Sam In xl2003, one could just double click on the dotted line which leads to/from the little sheet icon. This would surface a "Go To" dialog revealing the precedents/dependents. Maybe it works the same way in your xl2007?  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Dear Experts > [quoted text clipped - 10 lines] > > Sam Yes it does work and works perfectly - Why didnt I think of that. Thanks Max > In xl2003, one could just double click on the dotted line which leads > to/from the little sheet icon. This would surface a "Go To" dialog [quoted text clipped - 14 lines] >> >> Sam Welcome, SammyH SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Yes it does work and works perfectly - Why didnt I think of that. > Thanks Max
|
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.