Hope one of you can help.
In Visual Studio I have created an Excel workbook with dynamically generated Pivot Tables. I want to be able to format them using the styles in use in Excel 2010 (specifically Pivot Style Medium 2).
None of the XLPivotFormatTypes seem to do the job. I would appreciate any advice about further research I could do (or if anyone has a solution that would be great too