Can't Trace Dependents, Why?

[Ceeyee]

I have a very simple workbook with only one formula in Sheet1:


=VLOOKUP(A6,OFFSET(A1,0,0,3,3),Sheet2!A1,0)


However, when I click Trace Dependents on the A1 cell in "Sheet2", I got an error message

"The Trace Dependents command found no formulas that refer to the active cell"

Why??


This simple workbook can be found here. Can you replicate the problem? Or is it just me?
https://dl.dropbox.com/u/9846094/Public/Trace Dependents.xlsx

 

[Momentman]

I have a very simple workbook with only one formula in Sheet1:

However, when I click Trace Dependents on the A1 cell in "Sheet2", I got an error message

The trace dependents works on mine...and you referred to sheet2 instead of sheet1, was that a mistake?

 

[Ceeyee]

But I am getting the Error message. Please take a look at the screen shot.
I am using Excel 2010. Why?

 

[Ceeyee]

Can anyone help?
Thanks a lot.

 

[Andrew Poulsom]

For some reason the OFFSET function interferes with Trace Dependents. It will work if you remove it:

=VLOOKUP(A6,A1:C3,Sheet2!A1,0)