Refreshing a Pivot Table Deletes Columns

Question

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?

Answer 1

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.