exce+training - errors

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » exce+training - Errors

exce+training - Errors

resolvedResolved · Low Priority · Version Standard

Lynne has attended:
Excel Intermediate course

Errors

How can I trace an error

RE: errors

Hi Lynne

Thank you for your question.

Trace Precedents can be used to help troubleshoot where an error in a formula may have arisen from.

Trace Precedents is a button on the Formula Auditing toolbar, so you will need to display this toolbar on your screen. Then select the cell containing the formula producing the error; and click the Trace Precedents button.

What you should see is that a series of arrows will appear on the spreadsheet, indicating which cells are providing data to the cell with the erroneous formula.

If you click the Trace Precdents button a second time, this should show you which cells are providing data to the cells indicated by the first set of arrows.

Once you have been able to determine what is causing the error, you can remove the arrows from your screen by clicking the Remove All Arrows button on the Formula Auditing toolbar.

Amanda

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips


Server loaded in 0.1 secs.