Tips, Tricks, and Answers

The following articles are available for the 'Auditing' topic. Click the article''s title (shown in bold) to see the associated article.

   Accessing Dependent and Precedent Information
The auditing tools provided in Excel can provide some very helpful information about how your formulas and data are related to each other. If you want to grab the dependent and precedent information maintained by the auditing tools so you can use it in different ways, this tip can help.

   Counting Precedents and Dependents
Do you need to know how many precedents or dependents there are on a worksheet? You could count them manually, or you could let a short macro derive the information for you.

   Discovering Dependent Workbooks
When you starting linking information from one workbook to another, those workbooks become dependent on each other. Discovering which workbooks are dependent on the workbook you may have open can be difficult. Here's why.

   Tracing Dependent Cells
Cells that use the information in a particular cell are called dependent cells. Excel provides auditing tools that allow you to easily determine whether any other cells are dependent on whatever cell you want to analyze.

   Tracing Precedent Cells
Cells that affect another cell are called precedent cells. If you need to know which cells affect a particular cell, Excel provides some great auditing tools you need to discover.

   Understanding Auditing
Excel provides some great tools that can help you see the relationships between the formulas in your worksheets. These are known as auditing tools and are introduced in this tip.

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.