Forum home » Delegate support and help forum » Microsoft Excel Training and help » Tracing precedent and dependent entries

Tracing precedent and dependent entries

ResolvedVersion 2003

Tue 16 Sep 2008, 16:40 Delegate Graeme said...

Graeme has attended:
Excel Intermediate course

Tracing precedent and dependent entries

When checking formula that are incorrect, how can I trace sources of data into previous workboots if necessary?

Wed 17 Sep 2008, 14:11 Trainer Amanda said...

RE: Tracing precedent and dependent entries

Hi Graeme

Thank you for your question.

Are you referring to what happens if you use trace precedents on a cell where the formula is using data from other workbooks?

Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips

Tracing precedent and dependent entries

Tracing precedent and dependent entries

RE: Tracing precedent and dependent entries

Excel articles

Excel tip:

Recently used file list