I am using the export wizard activity in automation to export data to a .xlsm file. The file contains two pivot tables which contain conditional formatting in which the "applies to" range of the formatting is associated with a field in the pivot table, rather than a set range of cells (by selecting the "All cells showing "[field name]" values" option in the "Apply Rule To:" section of the conditional formatting editor.
When the export activity runs, the "applies to" range is changed to the specific cells occupied by the collapsed pivot table at that moment (e.g. A12:A30). However, the pivot table, when expanded, is much larger than that. When I expand, only rows 12:30 have the conditional formatting applied, because of the change to a static reference.
Is there a fix for this?