Thanks for the reply!. What i mean is that using
ConfigRaw configRaw = JsonHelper.ArrayFromJson<ConfigRaw>
With '={OtherSheet!A:A}' it causes configRaw to have 999 elements (all rows).
Thanks for the clarification. I'll have to try that! Have not seen behaviours like that before, but neither used that forumla, so I'll try and get back to you.
