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

Hi VictorExcelParis,

Did you check the above reply? If you still need help, please update us.

Regards,

Neha

Answer 2

I need use this code :

Option Explicit

Public nomfichier As String

Sub CommandButton1_Click()

 Dim Plage_Impression As String

    Dim a, b               As Integer

    Dim currentSheet     As Worksheet

    nomfichier = ThisWorkbook.Name

    Set currentSheet = Workbooks(nomfichier).Worksheets("OVERALL")

    ActiveSheet.Unprotect

    a = currentSheet.Range("L2").Value

    b = currentSheet.Range("L3").Value

    Plage_Impression = currentSheet.Range("A" & a & ":" & "K" & b).Address

    With ActiveSheet.PageSetup

        .PrintArea = Plage_Impression

        .CenterHorizontally = True

        .CenterVertically = True

        .Orientation = xlLandscape

        .Zoom = False

        .FitToPagesWide = 1

        .FitToPagesTall = 1

    End With

    ActiveWindow.SelectedSheets.PrintPreview

    ActiveSheet.Protect

End Sub

Answer 3

Hello Neha :

I try too .xlsx file same problem : 

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

Answer 4

Hi VictorExcelParis,

Since you are using Python to update cells and you want to use VBA code, we will move this post to Programming category (Excel / Microsoft Office Programming / Office 2019) so the community members with programming experience can share their suggestions with you.

Regards,

Neha

Answer 5

Hi Neha,

This probleme is from Excel, I don't see the goal to create {= in excel if we can't use !

Just tell me how I can't fix it. Like protected my formula for example.