Results 1 to 4 of 4

Thread: Error message when trying to amend pivot table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Error message when trying to amend pivot table

    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!!

  2. #2
    Board Regular
    Join Date
    Feb 2012
    Location
    Indianapolis, IN
    Posts
    188
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error message when trying to amend pivot table

    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.

  3. #3
    New Member
    Join Date
    Oct 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error message when trying to amend pivot table

    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







    Quote Originally Posted by MD610 View Post
    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.

  4. #4
    New Member
    Join Date
    Feb 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error message when trying to amend pivot table

    I'm having the same issue but the 'Merge & Center' button is not selected and is instead faded out. Any thoughts?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •