Error message when trying to amend pivot table

cowboy2153

New Member
Joined
Oct 18, 2011
Messages
7
I've created a pivot table using several fields via the automated field list. Now when I want to amend pivot table with an additional field (which is already listed) I receive the following eror message:

Cannot change part of a merged cell

How can I identify these "merged cells" and correct in order to add an aditional field to the pivot table?


Thanks to all in advance!!
 

MD610

Board Regular
Joined
Feb 7, 2012
Messages
188
Do you have a need for the merged cells? Are they supposed to be in there?

If not, I would just highlight the entire sheet, then under the Home tab on the ribbon, there should be a button for toggling on/off Merge & Center. Toggle it off for everything.
 

cowboy2153

New Member
Joined
Oct 18, 2011
Messages
7
AWESOME...
Thanks so much for the quick reply......By selecting unmerge, I can now add an additional field to the existing pivot table

Thanks so much

Have a great week
;)






Do you have a need for the merged cells? Are they supposed to be in there?

If not, I would just highlight the entire sheet, then under the Home tab on the ribbon, there should be a button for toggling on/off Merge & Center. Toggle it off for everything.
 

08730000000BrGM

New Member
Joined
Feb 21, 2019
Messages
3
I'm having the same issue but the 'Merge & Center' button is not selected and is instead faded out. Any thoughts?
 

Forum statistics

Threads
1,086,069
Messages
5,387,605
Members
402,071
Latest member
Nauef

Some videos you may like

This Week's Hot Topics

Top