Auto Refresh Pivot Chart

I have a Pivot Chart created in the same sheets.
I want the chart to be auto-updated each time the data is updated.

Tried

ThisWorkbook.RefreshAll

and it works but all other worksheet in the same workbook will be updated too.

What should be the VBA code to have only a particular Pivot Chart auto refresh?

How can I have the pivot auto refreshed using VBA?

I have this VBA code in the module:

Sub Search()
    
    With Sheets("sPCE")
        Set critRng = [Criteria] 'search base on date range
        Sheets("PCE").Range("A5:T1050").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=critRng, CopyToRange:=.Range("E17:O17"), Unique:=False
    End With
        Range("B17:O2000").Font.Name = "Calibri" 'set the font type and size
        Range("B17:O2000").Font.Size = 9
        ThisWorkbook.RefreshAll
  End Sub

When the search button was clicked, the Excel data will be updated and the Pivot Chart created using this data range will auto-updated as well.
But "ThisWorkbook.RefreshAll" will update my other Pivot Chart in other sheets which I want to avoid.

Thanks.
If I am not wrong, this code only applied if you have both the data and pivot chart in different sheets and it won't work if both in the same sheet.

Ok.let me try again as I am seeing error message

Sheets("sPCE").PivotTables("PivotTable2").RefreshTable

I keep getting the error message.
My pivot chart name - PivotTable2
Sheet name - sPCE

Capture.JPG

Please refer to the sample file, I want the chart automatic update as well when the search button clicked.
Can anyone help? Thanks in advance.