Hi Scott

Right click on the PTDesignDesignLayoutShow in Tabular form

--
Regards
Roger Govier

"Scott" wrote in message
...
I have a problem with the Excel 2007 pivot table layout that's different
from
the Excel 2003 pivot table layout. Is there a way in Excel 2007 to present
the pivot table the way data was presented in Excel 2003?

Example: Let's say I have four people with the last name of "Smith."
In Excel 2003 pivot tables, I could show all four "Smiths" with the first
name and last name together on the same row.

Col A Col B
Smith Joe
Smith Bill
Smith Mike
Smith Tom


In Excel 2007, I get the last name and first name on separate rows. In
addition, Excel 2007 only shows "Smith" once and then indents all the
first
names on a separate row.

Col A Col B
Smith
Bill
Mike
Tom

How can I get the first name and last name on the same row in Excel 2007
Pivot Tables?

Thanks,
Scott