As the title says, all my components run fine on their one, but when strung together I get an unexpected error which appears to stop the final component opening Excel (using excel app scope).
As the screenshot shows, the log at the start of the final invoke works, but the next step, which is the excel application scope which should open the relevant file, errors out. When I open this workflow and run it on its own, it runs just fine - barring the lack of inputs - so I was wondering what my cause this issue?
The input arguments are two data tables, one created by a “Read Range” and one from a “Get Clipboard”. The “Get Clipboard” data table used to be a “Read Range” activity, but for some reason that started prompting the Excel file to save which set off a sharepoint save, despite having deselected “Autosave” in the Excel Application Scope, and this file should not be saved, but I think I had the same issue when it was a “Read Range” so I doubt it’s that. Also if there were input argument issues I suspect they would have arisen before the initial log message was posted from this component.