Skip to main content

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?

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

the service account needed dbo permissions on the content databases.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings