Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trace Dependents

Status
Not open for further replies.

broekie

Structural
Joined
Feb 17, 2004
Messages
150
Location
US
I have something that occurred in Excel that has never happened to me before. I went to Tools --> Formula Auditing --> Trace Dependents to see if any cells referenced cell E24 in my spreadsheet. A box popped up that said "The Trace Dependents command found no formulas that refer to the active cell."

Based on this message, I removed the value in cell E24 since I didn't need it anymore. When I did that, a bunch of cells suddenly changed. Sure enough, I looked and they all referenced cell E24.

Why did I get the message box that I did when there were obviously cells in my spreadsheet that referenced cell E24?
 
That depends on the formula in the dependent cells. I don't think, for example, that Trace Dependents can track =INDIRECT() function evaluations.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
 
The formula in the dependent cells was just E24 times another cell. For whatever reason, it is working fine this morning. Weird, but problem solved, I guess.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top