Hi Folks,
I hope you are doing well. I have a use-case, where in an Excel file, my sheets are fixed, I have two sheets, but there now we have a total 4 pivot tables, in future that might increase, so the bot needs to refresh those pivot tables, my question here can make this refresh process dynamic, so in future, if pivot tables would be increased so bot can refresh them as well.
Cheers
Thanks for the reply, I cannot see this excel.allpivottables. Might be due to the UiPath studio version. And after writing Excel. it’s getting hanged.
I am not sure if my prediction is correct or not, I tried this approach from Windows mode, and it is working, I can see this option, but in my current project which is on legacy, there this option is not appearing, it is showing loading for a longer time.
Try this
well, I upgraded the packages and restarted the studio, and now it’s working, but here I want to mention that the data range should be correct, or we can use a table. Thanks for the quick resolution. I will mark it as a solution now.
Thanks again
Cheers!
Thanks for the response. Excel modern activity is working, but I tried this vba script, this is as well working.
Thank you
Cheers!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
