Trouble in pivot table while extracting the data from Excel. Working fine with build data table activities




I have extracted the data to create a pivot from build data table and it worked fine but once i start extracted data from excel , it give an error of data validation.
Here is the code.

dtAllRows.Compute(“sum([Amount])”,“Name=’” & row(0).ToString & “’”) worked fine with Build data activities but not while extracting data from excel.

Please help.