Force alignment on headings on chart for excel export
Hi,
I'm trying to force a right alignment on headings on a pivot table. I've tried setting all the usual stuff for headings in the 'Presentation'-tab on the chart.
Label - Right Data(Numeric) - Right Data(Text) - Right
Excel does not seem to read these settings when you use the 'Sent to excel' button or when you do the normal export to a excel file.
Is there any workarounds? I've testing the export to both Excel 2003/2007 and it does not read these settings in either of them.
Maybe I could force these settings in a Export Macro type? Any idea's would be appreciated.
