Hiii, Actually i want to refresh my pivot table using blue prism.but everydata rows are not fixed in the input files so if i created a pivot table first day with 1000 rows next day it will 1300 or 1500. Actually it is not fixed so refreshing the filter. When i refersh pivot using refresh pivot action in extended excel VBO it only reflect 1k data and missed the new rows so i want give the cell range and after i want to refresh my pivot. there is any code for this criteria to refresh pivot my giving cell reference.
Manually the steps is like: go to analyze then Change the data source and then click on the refresh.
so there is any code for changing data source and then refreshing?
------------------------------
Tejashri Nevase
------------------------------