Share via

Unable to add a field to Values section in Pivot table

Anonymous
2019-09-12T15:00:02+00:00

Hi, 

I'm having an issue adding a more fields to the Values section in my Pivot table, keep receiving the error message "the field you are moving cannot be placed in that area of the report."

After some investigation, I noticed that if a remove a few of the other fields I can add more. Is there a max # limit of how many fields you can have in a the Values section of a  Pivot table? I am using Excel 2016. 

If there is a limit, is there a way around this?

The purpose of this pivot table is to consolidate my company's business lines financials year over year, so every year I will need to be adding columns/values.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-09-12T15:18:00+00:00

    Hello CourtneyBrown4,

    Thank you for trusting us by participating with your questions.

    My Name is Andy, I am an Independent Advisor and it will be a pleasure to help you today.

    I hope this is very good, in response to your question I recommend visiting these links

    https://www.wikihow.com/Add-a-Custom-Field-in-P...

    https://www.wikihow.com/Add-a-Field-to-a-Pivot-...

    Note: This link is not a Microsoft Website. It seems to contain correct and secure information. Please be careful with advertisements on the site that may be promoting products classified as PUP for their meaning in English (Potentially Unwanted Products). Please do not download anything from that site.

    I hope you solve your inconvenience as soon as possible. Any other questions here I will be to help you.

    I wish you a fabulous day!

    Greetings.

    Andy.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2019-09-12T15:03:11+00:00

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments