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.
As per my use case I have to update source Data into a dedicated source data tab in a File having Pivot tab utilizing Source data tab. Once I paste the desired data-set into Source Tab and try to open the file, I am getting an error "We found some problem with the content "<file name">. DO you want us to try to recover........"
I have tried with newly created File (creating Pivot from the fresh). However getting same error. Any suggestion?
When I open the corrupted File, a pop-up window appears with message:
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)
Your pivot table, is the source an actual excel table? If so, Alteryx is not writing the data to your "table" which is a named item/range in Excel (something like [Table1]). Alteryx is overwriting the data in the space on the tab you are telling it to. So, that means that part/all of that table is being overwritten and your pivot table no longer has something to refer to. I think this error may specifically be coming from the fact that part of this table still exists but it doesn't know what to do.