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?

1 Answer 1

4

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

Classic layout

Further details here.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .