Forum Discussion
How to I stop Excel from inserting @ in a formula (dynamic array formula)
Hello Excel Forum,
I have noticed that Excel (without my acknowledgment) inserted @ sign in front of Dynamic arrays.
For example, Formula used to be
= Range.Name.1 + Range.Name.2
I have noticed a calculation error. And I traced the error to the formula being changed to....
= @Range.Name.1 + @Range.Name.2
I do not know how this occurred but it is causing the workbook calculation to be incorrect.
I would like Excel to stop putting @ sign altogether.
This appears to be happening "randomly" (I can not replicate the error) and I do not understand what triggers Excel to do this.
This is a serious issue for me because I am now constantly paranoid about having impartial calculations due to @ sign and unable to know if this had occurred without checking every line.
If anybody has suggestions or similar experiences please share them with me.
Thank you
1 Reply
- Patrick2788Silver Contributor