Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Formulas > Error Checking Smart Tag< Previous | Next > 

 

Check your Options

 
 

Check your (Tools > Options)(Error Checking tab, Enable background error checking) to ensure that this tag will be displayed.

 
 

The Error Checking smart tag will only be displayed if this option selected.

 
   

   

 

Smart Tag Options

 
 

The exact options that are displayed on the smart tag will vary depending on the type of error.

 
   
 

Divide by Zero Error -

 
 

Invalid Name Error -

 
 

Help on this Error -

 
 

Ignore Error -

 
 

Edit in Formula Bar -

 
 

Error Checking Options -

 
 

Show Formula Auditing Toolbar -

 

 

These options are also sometimes displayed as well.

 
 

Formula Omits Adjacent Cells -

 
 

Update Formula to Include Cells -

 

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