Refresh Multiple Pivots | SendHot Key | UI Automation | (Excel Automation UiPath)| Scenarios | RPA

[@GaneshPalaniappangilly]

You have unticked the check box of ampersand from the selector @17:00 . Why to remove it ? is it a must?

[@MukeshKala]

The Excel Element was "Queries and Connections" , However the Selector has identified it as "Queries & Connections". This might Break as &amp can sometime be omitted , Also here we have more stable elements which we can rely on. Other Option if you want to use this could be to use "Queries*Connections"

[@dattaveeravalli2446]

Hi Mukesh, In Reframework in process xaml, I want to build data table using add data row , but it's not adding data. finally have only one row in dt. how do we get total rows in datatable. I unable to use foreach because we know In_transistion item get only one row in every itration

[@MukeshKala]

The dataTable variable Should be global , if it is only restricted to process xaml it would reset after every run that is why you are getting only 1 record … Create the dataTable variable globally meaning it should be accessible to the entire project

[@dattaveeravalli2446]

Yeah I tried out argument and was assigned to global variable but still the datatable getting last replaced row

[@MukeshKala]

Run in Debug mode and keep a watch on the dataTable variable , see after which activity / xamls it is getting reset - Fix thata

[@mharish83]

Hello Mukesh, please share the input test data documents, in order to practice. Thank you

[@MukeshKala]

Hi, Please share your email Id and I will send it across. .

[@mharish83]

@@MukeshKala [e-mail]

[@MukeshKala]

Shared over email 😀

[@mharish83]

@@MukeshKala Thank you

[@sreyasidas5425]

Hello Sir, could you help me for this pivot refresh? I have send the hot keys to refresh the two sheets of my excel. However after pivot refresh, automatically the filters of pivots are getting changed . A null filter is always selected. Any help on this- what step to follow so that the filters does not change

[@MukeshKala]

Perform the refresh manually , save the file , re open and validate if you still get the same issue !