Hello, I have a condundrum where I am using a workbook which imports text data into a sheet, with ‘Fill down formulas in columns adjacent to data’ enabled.

My only problem is some of these columns have array formulas.

What I have discovered is that if there is additional rows of data imported into the workbook, Excel pops up a message saying “You cannot change part of an array” – Which I am guessing is because “Fill down formulas..” is checked on the import properties.

Can anyone think of another solution so I can have these array formulas filled down after text data has been imported?

Thanks