Remove Precedent Arrows – Removes tracer arrows from one level of dependents on the active worksheet. You can press this button multiple times to see additional levels. Trace Precedents – Draws tracer arrows from the cells that supply values directly to the formula in the active cell. If your worksheet contains errors then the Error Checking dialog box is displayed. Check columns for formula inconsistenciesĮrror Checking – Checks the active worksheet for errors.Time your workbook calculation for each worksheet to find bottlenecks.Find circular references (yes, all of them!).Easy Auditing of formula dependents and precedents, including object dependencies (charts, pivot tables, form controls, Validation formulas, Conditional formatting formulas, etcetera). Excel formula auditing taken to the next level! Formula auditing in Excel allows you to graphically display the relationship between formulas and cells.
0 Comments
Leave a Reply. |