Posted to microsoft.public.excel.misc

Brad

external usenet poster

Posts: 846

Trace Dependents - not working

Using Excel 2007

In cell (I1) on table Input!I1, I have the equation
=DATE(C1,C2+1,0)

On a different sheet, in the same workbook I have the equation

=NETWORKDAYS(TODAY(),Input!I1,Holiday)

When I'm on I1 and select Trace Dependents - I get nothing
When I'm on the second formulat and select Trace Precendents - I get I1 as
one of the precendents - what is going on?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
trace dependents	Susan B	Excel Worksheet Functions	0	November 20th 06 10:28 PM
Trace Dependents	Trot	Excel Discussion (Misc queries)	1	May 24th 06 05:55 PM
Trace dependents not working	Jo	Excel Discussion (Misc queries)	0	September 6th 05 02:59 AM
trace dependents	JBoulton	Excel Worksheet Functions	2	May 19th 05 09:04 PM
Trace Dependents and Precedents not working	Manish	Excel Worksheet Functions	0	April 11th 05 09:39 PM

All times are GMT +1. The time now is 08:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us