Remove all formulas but keep Values throughout workbook

[Rude Awakening]

Hey Guys
I have a workbook with 20+ sheets. All data on the sheets is pulled from a master sheet using the below formula
=XLOOKUP(Table25192224253134636668697231676869161[@['#]]&"|"&$B$1,Table251922242531346364[Count]&"|"&Table251922242531346364[Country],Table251922242531346364[CSI Group],"",0)

I need to remove all formulas but keep values on all sheets.

I've used the below macro based on this thread , but this returns #n/a for all XLOOKUP values

Sub Convert2Values()
Dim oSh As Worksheet
For Each oSh in Worksheets
oSh.UsedRange.Value = oSh.UsedRange.Value
Next
End Sub

 

[eduzs]

Maybe something like:
Backup your original file before doing any modification.
Test on a throw away copy of your workbook.

Sub test()

Dim oSht As Worksheet

Application.ScreenUpdating = False
For Each oSht In ActiveWorkbook.Sheets
    oSht.Activate
    oSht.UsedRange.Select
    With Selection
        .Copy
        .PasteSpecial xlPasteValues
    End With
    Application.CutCopyMode = False
Next oSht
Application.ScreenUpdating = True

End Sub