5/15/2023 0 Comments Lux delux codeIf a black dash line appears, it shows that there are cells related to the active cell that is located in a separate workbook.Click “Trace Precedents” again to continue auditing. The black dashed arrow points to a small icon. Double-click the black dash line to open a dialog box. The dialog box contains a list of the cells that are related to the active cell. If red arrows appear after running the precedents tool (instead of blue or black dash arrows), it means that the cells are the source of the error in the active cell.ĭouble-click any of the cells to open the separate worksheet and the specific cell. When auditing the cells, click the Remove Arrows button under the Formula Auditing tool section each time you move to the next cell so that you can distinguish between resolved and unresolved cells. Excel does not remove the arrows automatically, which can cause confusion. XYZ Limited uses Excel formulas to calculate revenue projections for each quarter for the year 2019, based on the previous year’s revenues. In the Excel worksheet below, cell F11 shows an error that needs to be resolved to get the total revenue projections for Q3. To get the source of the error, we can use the inbuilt Trace Precedents tool to audit the worksheet. Select the cell you want to audit (cell F11 in our case), go to the Formulas tab, and then click the Trace Precedents button. The command will display blue arrows that show the specific cells that affect the selected cell. The arrow points to the cell with the formula that references to the precedents.Ĭlicking the trace precedents button once more shows more cells that affect the value of the active cell. In our example, the error in F11 occurs because one of the cells selected when calculating the revenue projections was incorrect. Cell F2 was incorrect since it does not contain a numerical value for the quarterly projection of Q3. The cause of the error was human error, where the person doing the calculations selected the wrong cell. To correct the error, simply edit the formula and select the right cell for getting the total revenue projection for Q3. What Causes Excel to Produce a Beep Sound When I Click Trace Precedents? Once the error’s been resolved, you should remove the arrows manually by selecting the cell with an arrow and then clicking the Remove Arrows button under the Formula Auditing tool. It may also mean that the tool can’t track any further due to an untraceable item on the Excel worksheet.Įxamples of items that are not traceable using the formula auditing tools include: If Excel produces a beep sound, it means that the Trace Precedents tool is already done with tracking the cells, and there is no precedent cell.
0 Comments
Leave a Reply. |