Forum Discussion
Why do I Get an "@" automatically at the beginning of each formula?
In opposite, Excel with Dynamic Arrays is beta https://support.office.com/en-us/article/dynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-306b-4282-ae9d-aa88f5502fa2
As for @ in most cases you may safely remove it or simply ignore, more about this is here https://support.office.com/en-us/article/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34
It looks like formula was created in Excel with Dynamic Arrays, and you use it in pre-DA Excel. Is that the case?
SergeiBaklan Thanks for the prompt response.
It is a mixed formula with external (Bloomberg excel add-in) and excel forulas in it - arrays I guess?
for the Pre-DA thing, does this means this is pre-release, beta version testing?Thank you
In opposite, Excel with Dynamic Arrays is beta https://support.office.com/en-us/article/dynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-306b-4282-ae9d-aa88f5502fa2
As for @ in most cases you may safely remove it or simply ignore, more about this is here https://support.office.com/en-us/article/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34
- Tks Sergei, those links helped a lot.
In all, I rolled back my Office to Pre-DA by going to File>Account>office Insider>unsubscribe
then I updated Office
and Lastly I Removed and reinstalled my Excel Add-in
