Pivot Table Columns Disappear on Refresh

bosadev

New member
Joined
Feb 27, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2016
Currently running Excel 2016 (16.0.11231.20164) and am having an issue when refreshing a pivot table (see attached screenshot). Before refreshing, I have 6 columns but after refreshing, 2 columns disappear. How do I prevent this from happening? Why does it happen? Last week, was able to refresh and all was good but all of a sudden this started happening. I understand I can re-build the pivot table but I have multiple tabs and can't do that every time I need to refresh the data. No updates to Excel 2016 are outstanding and tried disabling add-ins but the issue persisted. Thank you so much for your help!

Capture.JPG
 
So December 31,2018 disappears. Probably because it doesn't exist or there are no values for December 31,2018 in the source data (taking into account any filters you have in the pivot table).
You might get it to stay if, for the field:
2019-03-30_220108.jpg


or for the whole pivot table you use Max or Automatic in:
2019-03-30_220159.jpg
 
Last edited:
Back
Top