Array Formulas Compile Incorrectly

XLS Padlock
1

I have noticed after compiling all my array formulas are converted from this format in a single cell:
=FILTER(Argument1,Argument2,Argument3)

into this format:
{=FILTER(Argument1,Argument2,Argument3)}

across the entire array initially produced by the original formula

This renders the workbook effectively useless and the formula no longer dynamic.

Please help.

2

Can you try to activate the following option to see if it solves your problem?

image
image811×507 41.6 KB

3

Yes i figured it out later that day. Thank you

Checking this option will fix the problem.
Don’t use array formulas without checking that box.

1 Like