Problem: When exporting from Excel Pivot and Excel Pivot View on a Workbook, if the existing Excel file has conditionally formatted cells, the cells will be moved and no format is applied.
Solution: ‘Excel Pivot View’ Export should work the same as the ‘Excel’ report output does and not remove existing conditional formatting in the Excel file (or move the cells down in case of the Excel Pivot View)
While the ‘Append rows’ option does work for ‘Excel Pivot View’, it doesn’t clear out any existing data in the file which is a huge problem.