CUBEVALUE and CUBESET functions

How can I assign an array value to a cubevalue and/or cubeset?

Currently I have this and it's working, however, if I have lots of criteria in the same dimension, Excel will give me an error message indicating that it's more than 255 limit

Please Login or Register  to view this content.

My question thus, if I have say 20 criterias, how can I put it as an array so that Excel will like it and not give me a 255 limit.

Haven't tried it with cubeset, but you could probably use Name Manager to create a Name with those values...