Printable View
Hi,
Microsoft Office Excel 2007 allows you to use many powerful settings to tweak the information in your pivot table. but still i like the I like the "Classic Layout" from Excel 2003 for Pivot Tables. Has anyone figured out a way to get Excel 2007 to display the Classic Layout ? or can anyone tell me how to create pivot table in excel 2007 ?
Thank you
Hi
To get a classic look of pivot table you can follow the two method given below
1.
Sub Macro1()
ActiveSheet.PivotTables("PivotTable1").RowAxisLayout xlTabularRow
ActiveSheet.PivotTables("PivotTable1").TableStyle2 = ""
End Sub
2.
If you wanted to select it via the menu/band buttons.
Select the pivottable
select menu Pivottable Tools->Design
upper left design is the one the resembles the old style.
Pivot Table in Excel 2007
- Open the Microsoft Excel spreadsheet program. Click "Start" on the main operating system menu. Then choose "Programs" and from the program menu select "Microsoft Excel."
- Choose a cell in a Microsoft Excel spreadsheet. Make certain the call range has a column heading. From the main tab menu, select the "Insert" tab, then in the table menu click on "Pivot Table."
- Select the data range to be analyzed. A user can either select a range of data in the current spreadsheet or choose data from an external source. Also, determine if the pivot will appear in the current worksheet or in a new worksheet.
- Create the pivot table in Microsoft Excel. With the correct data source selected and each of the columns has a heading, click "OK." The pivot table will appear either on a new or existing worksheet. Now check the data columns to display in the pivot table. Make sure the data in the pivot table displays correctly. Sometimes the pivot table will have formatting issue if the original table had labeling or data problems. Check the drag field boxes if there are errors in appearance or formatting. Experiment with the pivot table data by dragging the data into different fields until the pivot table display is correct.