Importing cells as text strings and not as formulas

[vonnjovi]

Good day, I've been trying to read through the community posts but I was not able to find a similar question.

I am trying to input an excel file into Alteryx.

In that Excel file, most of the cells are a result of Vlookups from another excel tab or workbook.

For example, a column called "Names" is sourced from another sheet via Vlookup.

When I input the sheet into Alteryx, the program reads the columns in a different ways, not the results of those formula.

For example, the "Names" columns show as 00:00:00 when imported into Alteryx.

What shall I do to make Alteryx read the intended cell values?

Thanks for your time!

[Raj]

@vonnjovi 
try to save excel file without formulas as this issue is due to bringing lookup values from different sheet.