Problem with the Function Filter and in General with the Function after I save .xlsm

Question

When I have { before = 

the function stopped update . So I must delete all function and write new one : =FILTER(Table1,Table1[POF '#]='POF Workbook'!A3,"") without {

But it's not me who write this  curly bracket . After I save and open all mu function in this sheet is change with  curly bracket before = 

What I can do please ? 

PS: F2 and CTRL+Shift+Enter doesn't work

Answer 1

The update is stopped and new information from table1 is stopped update: 

Answer 2

Hi VictorExcelParis,

Welcome to the Answers community.

Curly brackets show up when you enter a formula by hitting CONTROL+SHIFT+ENTER at the same time, instead of just enter as in

=MIN(IF(A1:A10,A1:A10))

which, when entered by hitting CONTROL+SHIFT+ENTER at the same time, will appear on the Formula Bar as

{=MIN(IF(A1:A10,A1:A10))}

The only time you enter these curly brackets yourself is when you feed some function a constant array as argument as in

=VLOOKUP(A1,{"a",1;"b",2;"c",3},2,0)

where {"a",1;"b",2;"c",3} represent a 2-column table.

Curly brackets are thus associated with the array formulas and constant arrays.

Regarding the error “You cannot change part of an array”, this error appears when you're trying to edit an array formula, and you're stopped in your tracks. You click the formula in the cell or formula bar, and you can't change a thing. Array formulas are a special case, so in this scenario, you can't delete cells in an array formula, but you can delete the entire formula and start over.

Besides, for the function not updating, please check if Calculation options in Formulas tab is set to Automatic.

Regards,

Neha

Answer 3

please check if Calculation options in Formulas tab is set to Automatic => YES

it's not me who save {=FILTER(Table1,Table1[POF '#]='POF Workbook'!A3,"")}

I use Python for update some cells in sheets1, I never touch Function and sheet4 where we have formula. After I save what I update in sheet1(not sheet4) the Function is change in sheet4 =>    =FILTER(Table1,Table1[POF '#]='POF Workbook'!A3,"") become {=FILTER(Table1,Table1[POF '#]='POF Workbook'!A3,"")}

and =SORT(RIGHT(UPPER(IF(UNIQUE(Table1[POF '#])=0,"",UNIQUE(Table1[POF '#]))),3))  become  => {=SORT(RIGHT(UPPER(IF(UNIQUE(Table1[POF '#])=0,"",UNIQUE(Table1[POF '#]))),3))}

so all Function in the sheet4 is updated.  What I can do ?

Answer 4

All function is breaking not only Filter !

And I try to create a new sheet with data it's same problem :

{=SORT(RIGHT(UPPER(IF(UNIQUE('PO List New'!A5:A165)=0,"",UNIQUE('PO List New'!A5:A165))),3))}

what can I do so that when I save (name.xlsm) the function does not change?

Answer 5

Hi VictorExcelParis,

I noticed the workbook format is .xlsm, may I know if same thing happens in .xlsx file?

Please create a new workbook for the test purpose, then add some data and enter any array function, check if you still see the same behavior.

Besides, may I know if you created the workbook in a different version of Excel?

Also, please provide the screenshot of Microsoft 365 Product Information. To get this screenshot, open Word or Excel on your system, click File>Account, capture the screenshot of all the information mentioned under Product Information. 

Regards,

Neha