AnsweredAssumed Answered

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

Question asked by jay.shah on Sep 14, 2016
Latest reply on Oct 10, 2016 by 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?