Share via

How to show PivotTable Fields (Filters, Columns, Rows, and Values appear blank)?

Anonymous
2024-08-05T06:33:04+00:00

Hey everyone,

Whenever I try to insert a Pivot table in Microsoft Excel, the PivotTable Fields (Filters, Columns, Rows, and Values) appear blank. I've attached a screenshot for reference. I've already tried uninstalling and reinstalling the app, using a different file, and updating the app, but I'm still facing the same issue.

I'm using Microsoft Excel for Microsoft 365 MSO (Version 2407 Build 16.0.17830.20056) 64-bit.

OS Edition: Windows 11 Home, Version: 23H2, installed on ‎10/‎18/‎2023, OS build: 22631.3958, Experience: Windows Feature Experience Pack 1000.22700.1026.0.

I am looking for help to solve this issue.

Kind Regards.

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

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-08-05T07:58:03+00:00

    Click the Tools gear, then select 'Fields Section and Areas Section Stacked'.

    1 person found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-08-05T10:15:59+00:00

    I;m sorry, I cannot help you with that. Please start a new topic to ask about update failing.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-08-06T04:43:26+00:00

    I will

    thank you

    0 comments
  3. Anonymous
    2024-08-05T09:46:45+00:00

    Thank you dear, it works.

    Whenever I try to update the MS Office it shows the following screenshot, could you help me, please

    Kind regards,

    Ahmad

    0 comments