Error in Write in File - Why is my workflow creating a temp output file?

Question

I have an Alteryx Workflow that saves the output to a worksheet within a Microsoft Excel workbook that is saved within a certain folder on our company's shared network. Every time I run the workflow I get the error message "Error in Write in File: link_to_filepath".

I notice that the file it's trying to save is a tmp file, rather than the .xlsm file specified. If I run the code and save it to a location on my local machine then the workflow runs fine and I don't have any issues outputting to the Excel file specified.

Qiu · Answer

@Simon_Lindsay 
You are saying that you were able to output other .xlsm files to the same location.
but only this particular flow is having issue?

I guess it will be better if we can get a glance of your actual flow. 😥

Simon_Lindsay · Answer

@Qiu

Thanks for your response:

1. Yes, I have the relevant write permissions on the server.

2. The point you make around the file being xlsm is not a problem as I've written other workflows that output to the xlsm format.

Qiu · Answer

@Simon_Lindsay

Based on your description, I can think of

1. Do you have the write permission on the server?

2. the File is Xlsm, which is macro embedded  excel, maybe your server prohibits direct operation of .xlsm file ,since its security concern/