Stop updating values pop-up when updating formulas

Hi Gurus,
Hoping someone can assist as all other searches/fixes don't seem to work for my spreadsheet!
I have a workbook that searches for and grabs values from closed workbooks with variable naming convention dependant on a cell value in the format "MmmYY".

I have attached a small sample- the actual workbook has over 100 lines and 15 colums with formulas to return data.

The updating of this workbook works with no issue using really simple VBA:

Sub Check_Data()
Range("$C$4:$N$83").Select
Selection.Replace What:="MmmYY", Replacement:=Range("$A$1").Value, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

When i try and clear the data using :

Sub Clear_TSSData()
Range("$C$4:$N$83").Select
Selection.Replace What:=Range("$A$1").Value, Replacement:="MmmYY", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

I get the "update values" pop up for each cell which i am trying to remove.

I have tried the below pieces of code but these didn't work for me and the update value box still appeared.

ThisWorkbook.UpdateLinks = xlUpdateLinksNever

and :

If Application.DisplayAlerts Then
Application.DisplayAlerrts=False
Else
Application.DisplayAlerts = True
End If

Hoping somone can shed some light on where i'm going wrong?

Cheers,
G