Hello All,
No matter what I try, I can't connect my one drive account. I only have a personal account. What I would like to do is set a trigger on excel 'cell in worksheet update'. When I add the activity, and I click on add worksheet, I try to locate the excel file, but it is always blank. and when I search my one drive folder it is always there.
Please help.
Click on Setting Icon in the activity-> Click on Add New Connection-> Connect One Drive with you orchestrator
If I’m not wrong your one Drive has been connected with UiPath just specify the workbook, cell Adddress and required fields It should solve the error.
Happy to help if difficulties faced.
Regards
Thank you, that did help to get to the next step. now when I search for the workbook, its not there. I see all the other folders, but there are no excel files. How do I get my excel file connected?
Make sure where your excel is stored by opening one drive in chrome. After that indicate the file.
Regards
Its stored in the correct places. I think its because its macros enabled. other files in othe folders that are just regular .xls can be found, but not macro enabled ones. So how do I set up a trigger for a switch activity that is triggered with a cell update with a macro enabled excel spread sheet?
