tracing precedent and dependent

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

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

Tracing precedent and dependent entries

resolvedResolved · Low Priority · Version 2003

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?

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


 

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips


Server loaded in 0.1 secs.