Cannot drag/drop fields in pivot table, can only right click to move them

[Gingertrees]

Strange problem with pivot tables. (Win 7 64-bit, Excel 2010.) I was trying to create pivot tables for a demo on said computer, and found that I cannot move the fields in my usual drag-and-drop way. Each field must be individually right clicked, and then must select "move to column" or "move to row" etc. Then from within the destination area, I must right click and choose "move up" or "move down" to reorder fields within the column/row/value/etc areas.

I've never seen this before, and it's a huge pain in the... neck. Ideas??

 

[RoryA]

You have to have the Classic layout enabled in pivot table options to be able to drag fields around, but you should be able to move items up and down within a field.

 

[Gingertrees]

No, that's not what I mean. I mean on the right side - I can't drag fields from the "Choose fields to add to report" area to the "Drag fields between areas below" part. I can only check them or right click and choose "move to row" or "move to ___". Isn't that weird and messed up? Is there some setting that could be causing this?

 

[RoryA]

That is weird. Can you actually drag them but not drop them at the destination area, or not even drag them?

 

[Gingertrees]

Can't drag them. I can hover over the fields in the "Choose fields" area, but even when I click-hold to try to drag one, the cursor doesn't change from the 4-arrowed cross when I try to drop the field.

I can drag and drop e.g. windows and other things on this computer, just not in excel pivot tables.

 

[BrokenHead]

Well, after all this time I am sure you could make it, but for those who can eventually have the same problem (as happened to me today) here goes the instructions to enable drag-and-drop:

Excel Options / Advanced / Tick the third box - Enable fill handle and cell drag-and-drop

 

[RoryA]

Welcome to the forum.

That's not actually the same problem at all, though - this one related to not being able to drag pivot fields in the pivot table field list, not to dragging cells.

 

[JohnnyB3591]

Uncheck classic pivot table and then hit okay, then check it again. That fixed the problem for me.