Share via

Pivot Table Calculation Fields disappear when adding data

Anonymous
2018-04-30T19:44:16+00:00

I have a pivot table that has a few calculated field based on the original data. When I add rows of data to the original and hit refresh, they calculated fields disappear. I add to new Columns at all. Just adding to number of lines.

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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-05-07T14:01:09+00:00

    Hi Keith,

    Please help provide the information Tina requested above when you are free. We are more than willing to help you solve the problem.

    Regards,

    Yoga

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-05-04T12:01:05+00:00

    Hi Keith,

    To better assist you, could you please provide the workbook via Private MessageI sent to you?

    Meanwhile, please also share with us the below information:

    1. Has the workbook word as you expect before?
    2. Some related screenshots to show how you perform the steps you mentioned above and then encounter the issue.
    3. What is your Office version (File > Account)? For example, Monthly Channel 1804 9226.2114. Please share with us its screenshot.

    Thanks,

    Tina

    Was this answer helpful?

    0 comments
  3. Ashish Mathur 102K Reputation points Volunteer Moderator
    2018-05-01T02:09:33+00:00

    Hi,

    That should not be happening.  Share the link from where i can download your file.

    Was this answer helpful?

    0 comments