Hi so i have this workflow action that query a workbook. but when i test the connection to excel services via the query excel services, the conection returns as "ok" but when i test the whole action i get the error:
"The execution returned an unexpected error.
The workbook cannot be opened."
I have checked all the permissions from the secure store service account to excel serveice account trusted account settings.
i also used my personal account to manually open the excel sheet from the library it opens, if i run my credentials through the workflow, it fails with the same error.
any ideas on what i should trouble shoot next?