This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
I have several workflows that are sending output to an Excel file. When I open the Excel file I always get a message "We found a problem with some content..." Do you want us to recover as much as we can?...." I always answer "Yes" and then I get a message about the repairs to the file which always says "Removed Records: Formula from /xl/calcChain.xml part"
I have no idea what any of that means. I'm able to use the excel file, and run the macros in it. However, I'd like to avoid those messages if I can before I hand these files off to someone else.
Thanks for the solution @32bit but it didn't work for me. There seem to be several different situations that cause this error.
In my situation, it is an .xlsx and not an .xlsm that acts as my template file.
I use a batch macro to create files using this template.
My sheet name is not unusually long, it is "sheet1".
I have used this workflow since 2019 on a monthly basis and it has only started producing this error (and data deletion in the .xlsx) this month. One of the only changes since it last ran successfully was that I upgraded from 2020.2 to 2021.1. I can no longer get it to run properly even with a previous month's data.
I have no fixed decimals.
Using @32bit 's solution did make the error (and the data deletion) go away, but it also broke all the vlookups in my template, therefore isn't a feasible solution in my situation.
I also added Block Till Done where two lines were coming out of the same tool, going different places. I let streams going to tab 1 finish first, and the rest were lined up with Block Till Done output 2 or 3.
I am encountering the same and tried to follow the steps of @32bit however, having issue editing the [Content_Types].xml file (opening in internet explorer). Is there any other way to handle this problem?
Any efficient and quick solution is much appreciated. Cheers.