Pivot Table operation is different

J

Jim

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?
 
D

Debra Dalgleish

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
The PivotTable field name is not valid (error) 1
Excel does not accept text format! 0
View Pivot Table Source data as a Data Table 6
Setting column width in a table with a macro is not working 0
Pivot Table Page Field value from cell in another worksheet 3
Hide Pivot Table Filters 1
Pivot Table Data Column Sort Excel 2007 1

Top