1 of 1 people found this helpful
This is because you are probably connected to live to the Excel sheet. Sets cannot be used in calculated fields with Jet data sources. Take an extract of the data source and the set will be able to be used in the calculation.
Hope this helps!
Can you please explain more in details?