Share via

Pivot table display error

Anonymous
2023-09-20T09:59:44+00:00

I have a data table with two pivot tables linked to it. Both pivot tables display the correct information except for one field on one table. For that particular field instead of the correct label, which is three uppercase letters, it shows one upper case letter two numbers and then two lower case letters. The second pivot table shows the correct data in the field.

Why is this error occuring and how do I fix it withouth having to set up the pivot table again?

I have had similar problems in the past and have always needed to re-instal the pivot table.

Microsoft 365 and Office | Excel | For business | 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 No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2023-09-20T11:02:20+00:00

    Could you share us a test file without sensitive information to reproduce your issue?

    For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

    Was this answer helpful?

    0 comments No comments