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?
Solved! Go to Solution.
Please check workbook path. If You have copied link from document library it does contain query string '?Web=1'. Then You get this error message.
unfortunately this is not the case. the URL, of the work book i am using to test, dose not have the query string. "siteurl"/CellPhoneExcelFiles/August%202016%20Test.xlsx