[Improvement] Suggestion: show tooltip with cell values when hovering over references, as in the formula bar

[santiago-afonso]

Hello. Just a small suggestion. It greatly help formula debugging if the AFE replicated this functionality of the formula bar on hover (https://insider.microsoft365.com/en-us/blog/check-your-formula-with-value-preview-tooltips-in-excel):

Currently that capability is unused for cell references (although it is used for formulas).

Thanks!!

[jack-williams]

Adding as an enhancement. It would be interested to learn when you prefer using the tooltips vs the built-in AFE debugger.

[santiago-afonso]

It would be interested to learn when you prefer using the tooltips vs the built-in AFE debugger.

Very, very often I get into one of these situations:

1. the The formula uses spilled (dynamic) arrays, which are not yet supported by the debugger. error (eg. Constantly getting "The formula uses spilled (dynamic) arrays, which are not yet supported by the debugger." even in simple single-cell references #83 (comment), although I never understood Nick's reply), or
   
2. Something along the lines of "the number of cells exceeds the debugger's limits" then a medium-sized range is passed as a parameter.

In either of those situations, the AFE debugger can't help at all. The Evaluate Formula can, but is cumbersome due to its small size and the need to go through every single step. Using the tooltips in the formula bar is quicker, and unlike the AFE, works in these situations which I encounter very often.

I don't understand the nature of the spilled arrays error, but it seems that it pops-up in the kind of situations where the AFE is most useful: in complex calculations involving Excel's new array-calculating formulas.