Hello,
I am a newbie at this, filling in for a coworker who is out. I have a process that was running fine for weeks but then it stopped working. Seems to be an issue clicking a filter drop down in excel. When I run it in debug, it typically works fine but the error comes when it runs unattended.
I was finally able to see it in debug mode to get some error details. Any ideas? I would appreciate some hand holding because I’m new at this.
You don’t automate in Excel by clicking around (UI Automation).
You should be using the Excel Filter activity.
https://docs.uipath.com/activities/other/latest/productivity/filter-x
Use “Filter” activity in your excel application scope
or
Use “Filter Datatable activity” Or Linq querys to filter your datatable after Read range
Ideally for excel you should not be using ui clicks and activities…there are excel related activitirs that you can use…
If you still want to use…then first check the screenshot if required button is present…
If present then first check the selectorsa…which anyways on excel most of them would be dynamic…if not try with adding delays
Cheers
ashokkarale
singh_sumit
alonica
SorenB
manasrlenka25
Firat_SECKIN_BULUT
Lahiru.Fernando
ruchirmahajan
RyanTSG
Nitesh