Excel 2007: The empty look of a pivot table

1

How is it that in Excel 2007, an empty pivot table sometimes looks like this:

enter image description here

and sometimes it looks like this:

enter image description here

So what's the difference? How can I make it always look like the first one?

Meysam

Posted 2012-10-11T09:24:35.607

Reputation: 630

Answers

4

By selecting PivotTable Options (from within a pivot table), Display, and checking Classic PivotTable layout:

Classic layout

Further details here.

pnuts

Posted 2012-10-11T09:24:35.607

Reputation: 5 716