How is it that in Excel 2007, an empty pivot table sometimes looks like this:
and sometimes it looks like this:
So what's the difference? How can I make it always look like the first one?
This question came from our site for professional and enthusiast programmers.
By selecting PivotTable Options (from within a pivot table), Display, and checking Classic PivotTable layout:
Further details here.