Hello, I've recently made the migration to Excel 2007 (from Excel 2003) and
can't seem to find a feature that I used very often. After dropping all the
column/row/data fields in my PivotTable, I would choose the option for
"Format Report" that had a bunch of canned report templates that could be
used to made the large report much more readable. I personally used "Report
6" all the time.

I know that Excel 2007 has all the pretty design stuff with the
colors/shading of rows, but the problem is that it just changes the look and
doesn't reformat the way the data is actually arranged. My PivotTable goes
on for 200 columns, so it's definately not in a printable format (this is
where the auto-format came into play). I've messed with the
design/grouping/style options, but cannot seem to recreate what was present
in Excel 2003. Any help is greatly appreciated!!