For this process, I am:
- Exporting Tableau data into a data table
- Dumping the Tableau data table into Excel
- Building a pivot table from the excel worksheet
- Adding slicers to the pivot table
The issue is, when I attempt to build a pivot table through the automation, the options to use slicers is greyed out and I receive the message below.
I also built a test automation and excel file (attached) to test if this happens within a new project, and the same error occurs. Does anyone know how to fix this error or a workaround? It seems like it only works if I manually build the pivot table outside of the automation.
NewBlankTask.zip (54.0 KB)
Test.xlsx (8.5 KB)