Pivot Tables drag & drop

  • Thread starter Thread starter Ty
  • Start date Start date
T

Ty

Sometimes when I attempt to create my Pivot Tables in 2007 it will not
let me drag and drop my data in the new sheet. It won't show the
small icon for columns or rows. I have to drag it to the box on the
bottom right(row labels, column labels...etc). Don't know how to do
the VALUES. But my problem is the drag and drop and icon displaying.

I only see this problem in some 2007 spreadsheets when I create the
new Pivot Table. Don't know if I'm doing something wrong.

Is this a know problem that can easily be resolved?

How can I fix this problem?

Thanks,
Ty
 
After creating the PivotTable, Go to the Options Tab in the PivotTable
Tools, then go to Options in the PivotTable group (Left corner) and
select Display.

In Display mark the checkbox Classic PivotTable layout (enables
dragging of fields in the grid)

Hope this helps!

Orlando Mezquita
 
After creating the PivotTable, Go to the Options Tab in the PivotTable
Tools, then go to Options in the PivotTable group (Left corner) and
select Display.

In Display mark the checkbox Classic PivotTable layout (enables
dragging of fields in the grid)

Hope this helps!

Orlando Mezquita
Click to expand...

Orlando, Thanks a bunch. Problem fixed.
 
Back
Top