Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Auditing

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.

 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.