Excel Pivot Table - Change default font

1

Is it possible to change the default font for a Pivot Table?

We have a report automation module in our application that populates an Excel spreadsheet with a result set from an Oracle SQL query.

Long story short, you upload a template document with all the formatting already done on all the right places, the automation populates the report and sends it off.

Problem is, my template is 100% but when I receive it back after it has been populated with data the font on the pivot tables have changed.

The pivot font in my template is Calibri, but when I open the report the font has changed back to Arial.

Any ideas are welcome.

Pieter van Niekerk

Posted 2012-08-28T13:48:41.433

Reputation: 643

No answers