Output Tool

[anupgupta12]

Hi There

Output tool is giving error :- "This process cannot access the file because another process has locked a porting of the file.

What's this error any idea, each time I get same error

[mceleavey]

Hi @anupgupta12 ,

This is because someone else (or yourself) has the file open or is editing the file.

You need to ensure your file is closed and nobody is accessing it when you run your workflow.

Alternatively, this could be because you are trying to overwrite a file that has a locked combination of cells, so the owner of the workbook has prevented anyone from overwriting it.

M.

[anupgupta12]

But the file is closed and I have not locked it. I have also restarted my system. Don't know what's wrong. 

[mceleavey]

@anupgupta12 ,

check within the file, I'm assuming it's Excel, that you don't have protected cells. If you do, Excel will stop Alteryx from overwriting that area.

M.

[anupgupta12]

Yes, its a macro enabled excel file.

[mceleavey]

@anupgupta12 ,

So you will need to remove the cell protection to allow Alteryx to overwrite the file.

M.

[anupgupta12]

I am trying to write two output in the same file, one output is written but 2nd output gives the error

[mceleavey]

Ah, in that case the problem might be that it's opened by the first process.

Can you share your workflow so I can build a fix for you?

M.

[anupgupta12]

Actually workflow is on official laptop that doesn't allow to send emails, can you tell me here?

[mceleavey]

You need to build a block until done process for the second output, but given they are both writing out to the same destination, you may need to wrap the second in a macro downstream of the first.

M.