I have a vbscript that runs in Power Automate to create a pivot table in an Excel file. The only step I cannot replicate is to "Repeat Item Labels" in the field settings. When I recorded the step in Excel, the result says "This action is not yet recordable".
If I run the script while in Excel, it works fine. The row labels are repeated in the pivot table.
When I call the script from Power Automate, the script runs and the output file is sent as an email attachment.
When I open the attachment, the row labels are not repeated.
Does anyone know how to work around this problem? I really need the labels to be repeated in the pivot table.
If I run the script while in Excel, it works fine. The row labels are repeated in the pivot table.
When I call the script from Power Automate, the script runs and the output file is sent as an email attachment.
When I open the attachment, the row labels are not repeated.
Does anyone know how to work around this problem? I really need the labels to be repeated in the pivot table.
