Take the 2-minute tour ×

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?

share|improve this question

migrated from stackoverflow.com Oct 11 '12 at 19:32

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 4 down vote accepted

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

Classic layout

Further details here.

share|improve this answer

Your Answer


