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.
This is for users who want to have an Excel XLSX Data Output which contains a Pivot Table that has formatted field settings such as "accounting" and "numeric".
Traditionally, you would go to a metric in the Pivot Table and --> Right Click --> Field Settings and then apply your preference to format your cells.
I saved the file, closed out and found this error message after I re-ran the Alteryx Workflow
When I clicked on "Yes" in the error prompt, the Pivot Table in the Excel was broken.
Interestingly enough while I was sharing the issue over web-share with Zach from Alteryx Customer support, he suggested that I do the following and it worked:
highlight the entire column
leverage the field settings in the ribbon
apply my field field settings and save/close file
Note: Prior to this, I had to re-create the Pivot Table after I found that the Pivot Table was broken in Excel.
I applied my field settings update using the "highlighting the entire column + using the field settings in the ribbon", saved the file and closed out.
Then I re-ran the Alteryx Workflow and the Excel Pivot Table had the field settings applied from the new approach that Zach helped me find as an alternative to my initial way of doing the field settings format.
Extra Credit: Ensure that you have the "Refresh data when opening the file" so that your pivot table has the latest and greatest data otherwise end-users will have to remember to manually refresh the pivot table.