I am having an issue with the bot I have built. This bot is designed to open an Excel file that is on a SharePoint site using the Excel Application Scope activity and then use a Read Range activity to copy the data in the Excel file to a data table for use later.
The issue I am having is that, at times, the bot will overwrite this Excel file with a complete new, blank Excel file and then will error out because the bot the Read Range activity will not work properly. This results in a lot of time being wasted for our Business User who has had all of their data they entered wiped out.
I have read through the Excel Application Scope activity documentation and found some options that appear to be able to disable this feature of overwriting the original Excel file, but these have not worked. I guess the bigger question is, why is the RPA not able to find this Excel file sometimes, but other times it works fine?
Any help with this would be appreciated. Some of our end users are getting really frustrated with this and I don’t blame them.