Refreshing a Pivot Table Deletes Columns

60795948 0 Reputation points
2023-06-21T15:50:45.7166667+00:00

Hello,

I'm currently working on a collaborative file that contains a lot of Pivot tables. When I refresh a Pivot that has 13 columns (12 months and a total), all the columns disappear except the one with the total. This also seems exclusive to my session since when other users try to refresh from their side, nothing changes and only the data gets updated.

Someone maybe has an answer to this?

Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
649 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,969 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Tanay Prasad 2,130 Reputation points
    2023-06-22T06:38:33.6966667+00:00

    Hi,

    There are a few potential causes and solutions you can try:

    1. Check if any filters are applied to the pivot table. Filters can affect which columns are visible after refreshing. Make sure there are no filters applied that could be hiding the columns you expect to see.
    2. Ensure that you are using the latest version of Excel and have installed any available updates. Microsoft regularly releases updates to address bugs and improve the functionality of Excel, including pivot tables.

    Also, is there any specific error message you're receiving?

    Try these steps and let me know if it's solved.

    Best Regards.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.