"Cannot change part of merged cell"

[Guest]

Need help!

I have created a pivot table in Excel and now trying to add another field
that appears in the field list. When I drag it over the pivot table to drop
it, I get this error: "cannot change part of merged cell", I did not receive
this error message for the other fields that I had selected.

Please help. Thanks in advance.

 

[silver]

Need help!

I have created a pivot table in Excel and now trying to add another
field
that appears in the field list. When I drag it over the pivot table to
drop
it, I get this error: "cannot change part of merged cell", I did not
receive
this error message for the other fields that I had selected.

Please help. Thanks in advance.

Is it indeed merged? Click on the cell you're wanting to paste to, go
to Format Cells then Alignment and uncheck the Merge box.