Hi. I want to use the excel online connector to run an excel script on spreadsheets received via email attachments using power automate.
The problem is when I try and run my script on the received spreadsheets, it says:
"We were unable to run the script. Please try again.\nThe script couldn't create a connection with Excel. Please try again."
When I try and open the received spreadsheet using excel online it says: "We can't show these features in the browser: Text Queries". I think this is causing the aforementioned error in the flow.
This fixes itself when I save a copy without the features. The problem is that I can't be going in and manually making copies of the received spreadsheets. How can I remove the unsupported features in power automate so that I can run my excel script?
Thanks.