Trace dependents on Table columns

MVP

So how come no-one told me you can now use trace dependents and precedents on formulas involving Tables?  

 

Is this one of those things that's been available for ages and I just didn't realise?   

 

I'm pretty sure it never used to work with Excel 2010 or 2007

 

1 Reply

Hi Wyn,

are you meaning something like shown in the screenshot? If so, then it works for my current Excel 2010 (Build 14.0.7188.5002). However, I must say, that I can't remember if it was also the case in the past and not some kind of update added it.

 

image.png

 

Best,

Mourad