Sharepoint Output - Dynamic File and Sheet names - Worksheet does not exist error.

[cochurch]

We have recently moved our storage system to Sharepoint and I have been struggling to convert some existing workflows to the sharepoint outputs and also run them on gallery. 

Current issue - I had a workflow that used a formula tool to establish the File Name and Sheet name dynamically. 

I want to output to the existing file name if it exists, or create a new one if not, and then also create a new sheet dynamically by a field name, and overwrite sheet if not.

I've attempted to set this up in the sharepoint output tool but am getting an error of "Worksheet does not exist".

I then tried to establish the file and sheet name in a formula tool again and got an upload error of  "run time error error while uploading file but expected one of bytes, unicode"

Looking for any guidance - I am able to run the workflow successfully if overwriting the FILE but not Overwriting the Sheet.

[finman]

I have this exact problem.

Overwrite File works.

Overwrite Sheet gives "Worksheet does not exist" error, but the worksheet does exist.

Append says that it completed successfully, but no additional rows are appended to the sheet (I added new data).

Were you able to work it out?

[aihnen]

Similar issue and still looking for a solution. I have a workflow that dynamically overwrites existing sheets based on a sheet name column. The sheets exist and it works on desktop but when on server I get the "Sheet does not exist" error. Confirmed it is not updating my excel document, but all do sheets exist. Anyone figure out why this is occurring?