Trace Dependents Not Working in Excel 2019

[Roncondor]

Hi

Periodically Trace Dependents stops working in Excel 2019 and says no dependents even when clearly there are

(There are no circular references, so that is not the problem)

Per the example in the attached JPG, I opened a brand new spreadsheet. Put values in A1 and B1 and set C1 = to A1 + B1

When I traced dependents on B1, it said "No Formulas reference the active cell"

Any thoughts?

 

[Phil GS]

Works OK for Excel 365.
Obviously no precedents.
Doesn't work with space before = sign.

 

[Roncondor]

Works OK for Excel 365.
Obviously no precedents.
Doesn't work with space before = sign.

There is no space before the equal sign.

I was using "Show formulas" [CTRL ~] so people could see the formula

 

[Phil GS]

There is no space before the equal sign.

I was using "Show formulas" [CTRL ~] so people could see the formula

I didn't say there was a space in your example.
I said it threw an error when I deliberately put a space before the = sign.
Spaces are easily missed.