Values or formulas not inserted

There is a limit to the number of dimensions the Insert Block and Insert Value tasks can support when inserting a block of data or values. The maximum number of dimensions that the tasks can support varies depending on which task is used and the writability of the data source, see this table:

Data source type Insert Block supports Insert value supports
Read-only 14 or fewer dimensions 29 or fewer dimensions
Read-write 14 or fewer dimensions 14 or fewer dimensions

If a dataset exceeds the supported number of dimensions, an MPCData (or CBData) formula is not inserted, and no value is displayed. There is no workaround for this issue.

For more information, see Cell formula constraints.