locked
Change PivotTable defaults permanently RRS feed

  • Question

  •  1.       Hi Each time I setup a PivotTable I change PivotTable Options/Display to Classic. I do this so that I can drag fields to the columns.  I would like to change the defaults to do that.  If that is not possible I would like to understand how Excel 2010 will allow me to easily establish column headers.

    2.       For each field I also have to go into the Field Setting and change Subtotals to None.  I would like to understand how to make this the default setting for this area.  If that is not possible I would like to understand how Excel 2010 will allow me to easily setup fields that do not subtotal.

    Monday, December 20, 2010 6:52 PM

Answers