Version Mismatch Error

[akvsachin]

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Output-issue/m-p/1404336#M3483...

I was following this solution for dynamic folder creation and multiple sheets into one excel file.

After running the workflow there's no error, but the excel file has version mismatch kind of error. And if I remove render tool part, then the excel file generated by Output data tools are perfectly working.

Can anyone please help how to correct this ?

[Gaurav_Dhama_]

So, in that thread, I used the file that I created using render tool. So first I created an excel file using render (a blank excel) to get the sub folder, then I used the normal output tools to update values in it.

Can you post a screenshot of the error?

[akvsachin]

Hi @Gaurav_Dhama_ 

I'll share the screenshot a bit later.
Description of the issue is as: Excel file is generated perfectly, so there's no issue in the workflow displayed as such. The issue when I try to open the excel file. It says somethings like, would you like to recover the file as much as possible. And after selecting yes, seconds later, it shows as failed to recover the file.

[Gaurav_Dhama_]

This generally happens when something is wrong with the path you are using to output the data.

Can you share the last part of the path or screenshot of the same, if sharing full path is not possible.

I will try to send you one example once i open my laptop.

[akvsachin]

Hey @Gaurav_Dhama_ 

This is the error message of Excel:

 

The FullPath going into Render tool is as Z:/.../.../2025/July/ODs June 2025.xlsx

The thing is when I disable the render tool, the Full Output Path that goes into

1st Output tool: Z:/.../.../2025/July/ITs June 2025.xlsx|||Execute$

2nd Output Data Tool: Z:/.../.../2025/July/ITs June 2025.xlsx|||Delete$

[Gaurav_Dhama_]

Check attached workflow, see if you can identify the difference in any settings.

[Gaurav_Dhama_]

Additionally, you can also try wrapping your Sheet name with backtick ` if you have $ sign or any special character. It is usually with tilde on left side of Number 1 in keyboard.

Make sure you only wrap your sheetname in it and not the file name too.

[apathetichell]

are you creating all of your sheets in the render tool --- or only some of the sheets? If you are combining file creation with both render and output data in the same workflow ---> you MUST create all sheets in the render tool. after creating you can write over the template sheets (let's say Execute and Delete) via Output data --- but they must be created via the render tool first.

[Gaurav_Dhama_]

It actually depends on how you make it. So, Render tool I use only to generate a subfolder, the file itself is not much relevant.

First Output data tool Overwrites my excel file, then if there are other output data tools, they can just create a new sheet.

It is important to understand how you are using render tool, if its sole purpose is to create subfolder, then just overwrite the file it created, so that in the end you still have just one file as output.

Trying to use rendered output may give you errors, so best is to just overwrite it with the output tool, then keep updating the same file.