Sep 18 2019 10:38 AM
Why do I Get an "@" automatically at the beginning of each formula? The formula works perfectly but it automatically creates the "@":
=@IF(ISBLANK(H265);IF(@BDS($C265;I$1;"Dir=V";"EndCol=2";"EndRow=1";"cols=2;rows=1")="#N/A Field Not Applicable";"-";BDS($C265;I$1;"Dir=V";"EndCol=2";"EndRow=1";"cols=2;rows=1"));BDP($H265;$B$1))
Sep 18 2019 10:45 AM
Sep 18 2019 10:46 AM
It looks like formula was created in Excel with Dynamic Arrays, and you use it in pre-DA Excel. Is that the case?
Sep 18 2019 10:53 AM
@Sergei Baklan 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
Sep 18 2019 11:09 AM
SolutionIn opposite, Excel with Dynamic Arrays is beta https://support.office.com/en-us/article/dynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-...
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-c1c9...
Sep 18 2019 11:25 AM
Sep 18 2019 11:30 AM
@VitorT , I see, so you created your formulas in Insiders version and now see in regular one.
Nov 07 2019 10:26 AM
Hi Vitor,
I have the same issue and it was breaking my formula functions. See post below. However I noticed that Excel stopped automatically inserting the "@" symbol without any new updates that I know of. Still version 1910.
Sep 18 2019 11:09 AM
SolutionIn opposite, Excel with Dynamic Arrays is beta https://support.office.com/en-us/article/dynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-...
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-c1c9...