BUG in Excel re formula precedents

Hi, I thought I’d share this to get your thoughts. I have only 2010 – does anyone get the same with 2007, 2013, 2016, etc.?

Steps to reproduce:

1. Create a new workbook with at least two tabs.

2. On one tab make a table (ListObject) with headers and data
a. In cells A1:A2 enter a label (for the header) and a number (for the data point)
b. Select A1:A2, hit Ctrl-T to make a table, and click OK.

3. On another tab (cell A1) begin entering a formula by typing an equal sign (=).

4. In formula-entry mode switch to the tab with the small table, click cell A2, and hit Enter to finish the formula.
It will look like "=Table1[HeaderLabel]".

5. With the formula still selected click the Trace Precednts button on the Formulas ribbon.
BUG: it says there are none!

6. Go back to the small table, right-click it, and choose Table / Convert to Range.

7. Go back to the formula cell, and click Trace Precedents.
This time it works: you get a tracer arrow to the other tab.

8. Hit Ctrl-Z to undo converting the table to a range.

9. Go to the formula cell, where you'll still see the tracer arrow, and double-click the arrow.
BUG: the dialog box of links is empty!

This doesn't happen if the table and the formula are on the same tab.

2016 (64) - cannot reproduce this "bug" because it works normally.

sandy666, I was able to reproduce this in 2016 (32-bit Office running on Windows 10 64-bit). Are you sure you followed the steps exactly?