PAfE - TM1ELLIST - returns just 1 element

[Ganos Lal]

Hello,

We are facing a problem using PAfE 2.0.81.3 with PAW 2.0.79. PAW server and database is the same in this test.
On one side I use my personel notebook with Office 365 x86. For example we tried the formula =TM1ELLIST("24retail:organization";;;"Caption_Base"). The result is a list of the elements of the dimension as expected.
On the other side we have a Terminal server with Office 2019 x86 using the same formula, the result ist only "100". See screens attached.

Some customer using Citrix with Office 365 where the formula works correct and another one also using Ctirix and Office 365 it just returns one elment.
So we expect the problem to be somewhere in Windows oder Excel, but don't know where to check.
Any suggestions?

Thanks

[gtonkin]

Do other dynamic array type formulas work in the Citrix environment?

[Ganos Lal]

No, they don't work. But it works on my laptop.
I couldn't find any checkbox to activate that feature, is there anything that i need to install first? Examples from Microsoft are available for Office 2010-2019 and 365, so I don't think it's a problem of the version.
https://support.microsoft.com/en-us/off ... 016_-_2019

Thanks so far