WorkBook Read Range: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index

Help Studio
9

Thank you. I have tried copying the data which I need to read in some sample excel. I kept the range same. There it worked. As per my observation , this activity of workbook (Read range , read column , write range) is not working if the excel contains pivots n all. In the regular excel (without pivots) its working on the same data.

I am not sure if my observation is correct.