Importing Excel sheet - Reference Values are not recognized

[lkng2001]

My workaround is to loop through the parameter's values and remove the "[]" from "=[]Sheet1!A1"

Code:

Function RemoveBracket(strSheetName)
    RowCount = Datatable.GetSheet(strSheetName).GetRowCount
    For i = 1 To RowCount
        DataTable.GetSheet(strSheetName).GetParameter("ParameterName").ValueByRow(i) = "=Sheet1!A1"
    Next
End Function