Refresh Pivot Tables in the sheet

[Anil_G (Anil Gorthi)]

@siddhi

in end column value here you have to give the end column like :G or :R

cheers

[Kunal_Jain]

@Anil_G
Where do I need to specifically add that value?

[Anil_G (Anil Gorthi)]

@Kunal_Jain

It should be like this

Excel.Sheet("Sheetname").Range("A" + (dt.RowCount+1).ToString + ":G" + Excel.Sheet("Sheetname").RowCount.ToString)

Cheers

[siddhi]

@Anil_G
still the same error is coming.

Thanks.

[Anil_G (Anil Gorthi)]

@siddhi

Can you please print this in log message first and show it

Cheers

[siddhi]

@Anil_G

Here it is.

[Anil_G (Anil Gorthi)]

@siddhi

I want you to print everything inside range …please

Regards,
Anil Bhargav