query excel services action returning "The workbook cannot be opened." error

[jay_shah]

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?

[mlauer]

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.

[jay_shah]

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

[jay_shah · Accepted solution]

the service account needed dbo permissions on the content databases.