Hi Team,
I’m working on an Excel automation using UiPath Studio where I add a dropdown list to a worksheet. The dropdown gets created successfully and the bot completes execution without any exception.
However, when I manually open the Excel file after the bot runs, I see the following popup:
“We found a problem with some content in ‘filename.xlsx’. Do you want us to try to recover as much as we can?”
On clicking “Yes”, Excel opens the file and displays a message that data validation from one of the sheets has been removed.
I’ve attached the screenshot of the popup and the warning.
Could anyone help me understand why this issue is occurring and how to fix it while setting up dropdowns using UiPath?
Thanks in advance!
