Outputting problematic Excel Files, need recovery each time opening resulting reports

[josh_jenkins]

Hello, when outputting reports from alteryx into excel files, every time I open them I get a message from Excel that states, "We found a problem with some content in 'YourFileName.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, clock Yes." This happens with most any excel file I output that is overwriting existing sheets. I also get this message from output reports when using Blob tools and templates, etc. Is there a resolve?

[apathetichell]

Can you try `Sheet$` instead of 'Sheet$'... 

you should be able to test this by bringing in a sheet name with a special character or space in it via input data. now attach an action tool to your input data and see the formatting it's natively providing.

[mbogusz]

That didn't work for me. It's still giving the error "Repaired Records: Worksheet properties from /xl/workbook.xml part (Workbook)". Maybe this is because I'm trying to write to a folder location that OneDrive is syncing?

[apathetichell]

throw a sample location of the filename/sheet/range into this thread. Can I confrim that you are writing via output data--- not render -- and that you are using the ` next to the 1 on the keyboard?