Excel Formula

[restya_raju]

Hi,

I had few things on check on excel report that is generated automatically. But when I import that on Alteryx, it shows me the formula for it instead of VALUES.

Could anyone help me with this issue, I need to view values in excel instead of formula.

[binuacs]

@restya_raju How you are seeing the data in the Excel file? are they showing the values of formulas?

[restya_raju]

In Excel file I can see Values.

[binuacs]

@restya_raju Can you screen shot your input file settings

[restya_raju]

Sure!!

[binuacs]

@restya_raju try turn off AMP engine and try again, if that not works provide a sample file for test?

[restya_raju]

I tried turning off AMP engine, but still I can't see value.

[binuacs · Accepted solution]

@restya_raju It seems that you are reading from Sheet1 which is hidden , change the sheet name from the input tool to Report and try again

[restya_raju]

I didn't notice that. Now its working, Thank you so much!!