Mr.Sam Mathai Chacko I only answer queries or questions .. if you do not like my answer you propose another solution ...... and everyone happy!!!
Chilexcel 2012/8/3 Sam Mathai Chacko <samde...@gmail.com> > Rajan isn't asking about Formula Auditing, which I am sure he is aware of. > His question is about the difference between Trace Precedents and Trace > Error which are two separate features in Excel. > > Please read my post before. > > Regards, > Sam Mathai Chacko > > > On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel <chilexcel...@gmail.com> wrote: > >> Rajan >> >> >> >> These tool in Excel allows us to Trace Precedents in a formula, Trace >> Dependents , Show formulas, Error checking and Evaluating formula in Excel. >> [image: Imágenes integradas 1] >> >> detail >> >> >> *Trace Precedents:* When you click this button, Excel draws arrows to >> the cells (the so-called *direct precedents*) that are referred to in >> the formula inside the selected cell. When you click this button again, >> Excel adds "tracer" arrows that show the cells (the so-called *indirect >> precedents*) that are referred to in the formulas in the direct >> precedents. >> >> *Trace Dependents:* When you click this button, Excel draws arrows from >> the selected cell to the cells (the so-called *direct dependents*) that >> use, or depend on, the results of the formula in the selected cell. When >> you click this button again, Excel adds tracer arrows identifying the cells >> (the so-called *indirect dependents*) that refer to formulas found in >> the direct dependents. >> >> *Remove Arrows:* Clicking this button (or the Remove Arrows option on >> its drop-down menu) removes all the arrows drawn, no matter what button or >> command you used to put them there. >> >> *Show Formulas:* To display all formulas in their cells in the worksheet >> instead of their calculated values (just like pressing Ctrl+`). >> • *Error Checking*: When you click this button or the Error Checking >> option on its drop-down menu, Excel displays the Error Checking dialog box, >> which describes the nature of the error in the current cell, gives you help >> on it, and enables you to trace its precedents. Click the Trace Error >> option on this button's drop-down menu to attempt to locate the cell that >> contains the original formula that has an error. Click the Circular >> References option on this button's drop-down menu to display a menu with a >> list of all the cell addresses containing circular references in the active >> worksheet. >> >> >> *Evaluate Formula:* Clicking this button opens the Evaluate Formula >> dialog box, where you can have Excel evaluate each part of the formula in >> the current cell. The Evaluate Formula feature can be quite useful in >> formulas that nest many functions within them. >> >> Chilexcel >> >> 2012/8/3 Rajan_Verma <rajanverma1...@gmail.com> >> >>> * * >>> >>> *Hi Group,* >>> >>> * * >>> >>> *Is there any difference in Trace Precedents and Trace Error in Excel??* >>> >>> * * >>> >>> *I don’t need any link to see because I have already Google it.* >>> >>> * * >>> >>> *Regards* >>> >>> *Rajan verma* >>> >>> *+91 7838100659 [IM-Gtalk]* >>> >>> ** ** >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >> >> >> >> -- >> Visita ; http://sites.google.com/site/chilexcel/Home >> Visita ; http://www.youtube.com/user/timextag41 >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> > > > > -- > Sam Mathai Chacko > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
<<Formula-auditing-Group-in-Excel-2007.jpg>>
