L
Legacy 103054
Guest
I have a worksheet that I want to export to a pdf. Several of the workshets have pivot charts in them and when I export to a pdf the pivot chart data table loses it's formating, Three of the rows have percent with1 decimal place and 3 rows have number format with commas. The worksheet looks fine and when I use a pdf printer it looks the same, but when I use VBA exportasfixedformat to pdf the data table in the pivot chart is has a general format with 9 decimal places. The pivot tables in the pdf have the proper formating in the pdf.