Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Auditing > Circular Reference Toolbar< Previous | Next > 

 

This toolbar can only be manually displayed when an open workbook contains a circular reference.

 
   

 

 Navigate Circular Reference - Lists all the cells that contain circular references.

 
 

 Trace Dependents - Draws tracer arrows from the cells that have formulas directly referring to the active cell.

 
 

 Trace Precedents - Draws tracer arrows from the cells that are directly referred to by the formula in the active cell.

 
 

 Remove All - Removes all tracer arrows from the active worksheet.

 

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >