I have a pivot table with background color for column headers. When i export to excel it is getting exported with the background color. I dont want the background color to be exported.
Also when we drag the column values as column header there is space in the header and it is showing as a blank column when the pivot table is exported to excel using send to Excel option and the same is almost work fine when we use the export option. Why there is a difference. is it a bug?