| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table operation is different
Why is it that the first pivottable I created allows me to drag fields from
the "PivotTable Field List " window directly to the spreadsheet diagram of a pivot table, and place them there, while on my second machine, I can only create the columns, values, rows, filters in the "PivotTable Field List "window"? I have to change the columns in the window on the second sheet, instead of right on the spreadsheet with the first. Did I change a setting somewhere that I need to adjust? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table operation is different
Right-click the pivot table, then click PivotTable Options
In the PivotTable Options dialog box, click the Display tab Add a check mark to Classic PivotTable layout Click OK Jim wrote: Why is it that the first pivottable I created allows me to drag fields from the "PivotTable Field List " window directly to the spreadsheet diagram of a pivot table, and place them there, while on my second machine, I can only create the columns, values, rows, filters in the "PivotTable Field List "window"? I have to change the columns in the window on the second sheet, instead of right on the spreadsheet with the first. Did I change a setting somewhere that I need to adjust? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
| Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Linear Mode
