Array Formulas Compile Incorrectly

ihn195

New member
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.
 
Last edited:
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.
 
Back
Top