I converted a .tas automation file to run in TDP 3.4. One of the outputs is an Excel file based on a pivot table template as described in your video:
My template has 2 tabs: PivotSheet and DailyData. The Select to File advanced option has Worksheet Name: ‘DailyData’ identified and Clear Worksheet data checked (or not checked; I tried both ways). ‘Start export at’ = A1. The PivotSheet has the pivot table based on the DailyData. The excel pivot table option to refresh upon opening is set.
When it runs in TDP 3.3 or 3.4, it generates the excel file to the DailyData tab but the Pivotsheet is lost.
Is this lost functionality, or am I missing a parameter somewhere?