Can you change the default pivot table design report layout to tabular form?

Question

When making a pivot table I'd like to be able to change the default settings such as...

design report layout to tabular form

turn off grand totals

turn off subtotals...

Thanks!

Answer 1

What follows is for the 2007 version but I expect 2010 to work in a similar, if not identical, fashion.

DESIGN REPORT LAYOUT TO TABULAR FORM

1. Click somewhere in the Pivot Table so that:-

PivotTable Tools

 - is highlighted in red in the Title Bar (at the top of the EXCEL window towards the middle).

2. In:-

PivotTable Tools

 - click on the:-

Design

 - contextual tab then:-

Layout group

 - click on the drop down arrow to the right of:-

Report Layout

 - then click on the required choice.

TURN OFF GRAND TOTALS

1. Click somewhere in the Pivot Table so that:-

PivotTable Tools

 - is highlighted in red in the Title Bar (at the top of the EXCEL window towards the middle).

2. In:-

PivotTable Tools

 - click on the:-

Design

 - contextual tab then:-

Layout group

 - click on the drop down arrow to the right of:-

Grand Totals

 - then click on the required choice.

TURN OFF SUB TOTALS

1. Click somewhere in the Pivot Table so that:-

PivotTable Tools

 - is highlighted in red in the Title Bar (at the top of the EXCEL window towards the middle).

2. In:-

PivotTable Tools

 - click on the:-

Design

 - contextual tab then:-

Layout group

 - click on the drop down arrow to the right of:-

Subtotals

 - then click on the required choice.

Does that give you what you want?

Answer 2

Hello Mike,

Thank you for posting the question in Microsoft Community.

Issues related to Pivot table would be better addressed in TechNet forum. Click and the link below to post your query in the following TechNet forum:

http://social.technet.microsoft.com/Forums/en/excel/threads

If you have any other questions related to Office products, reply and I’ll be glad to help you.

Thank You.

Answer 3

That is how you change it in the pivot table. The question we all want answered is how do you avoid having to do this on every @$#!/$ table. How do you change the DEFAULT?

Answer 4

Did you find an answer to your question ?

Answer 5

Hi,

Since your query is regarding Pivot table, you may also post this in TechNet forum for better suggestions.

http://social.technet.microsoft.com/Forums/en/excel/threads

If you have any other question, feel free to ask.

Thank you.