GetExcludedValues from vba when ALL values are selected
when you apply a SELECT ALL selection on a field, you can not get its excluded values any more.
My aim is to output a string with Markets which do not have data in the selected period.
The field function GetSelectedValues works fine until SELECT ALL is applied. After this all the functions getting various values return 0 except for the GetSelectedValues. The latter one returns only the selected elements, not ALL the values.
In my case I have a total of 40 markets. For January 2012 I have values for only 10 markets. Usually GetExcludedValues would return the remaining 30 values. When I select all values, GetSelectedValues function returns 10 selected markets. All the other functions (getExcludedValues, getAlternativeValues etc.) return empty arrays.