Hide Pivot Table Filter Arrows???

[jonandabby]

I often use pivot tables in MS Word reports. Those pivot tables often use filters in the column headers. In past versions of Excel, I was able to highlight the pivot table's content on Excel, copy it, and paste as enhanced metafile into the word document, and the filter arrows were not included in the resulting graphic. I can't use the regular paste function - I am often using charts that have to fit into multi-column pages, so putting the chart in as an embedded worksheet doesn't work with the size restraints of the document. I can't figure out how to do a cut-and-paste of a graphic version of the spreadsheet into Word without having the arrows show up in Excel 2010.

Is this possible? Or did they remove the ability to hide the arrows?

 

[jonandabby]

Anyone have any ideas?

 

[SFDCUtah]

I am hoping for an answer to this question as well. The closest I have got was to go into the Pivot table options under display and uncheck 'Display field captions and filter drop downs.' Unfortunately this removes the fields at the top and you can't just add new values either. I would love an answer as I hate having some arrows and some without since some are row labels and others values. The arrows look bad in Powerpoint!

 

[XL&ME]

On your pivot table sheet, click inside the pivot table and go to the Design Tab and in the far right click on Field Headers. I think this will dow what you are looking for.