Results 1 to 2 of 2

Thread: Pivot Table Columns Disappear on Refresh

  1. #1
    Neophyte bosadev's Avatar
    Join Date
    Feb 2019
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Pivot Table Columns Disappear on Refresh



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

    Click image for larger version. 

Name:	Capture.JPG 
Views:	523 
Size:	40.8 KB 
ID:	8936

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,568
    Articles
    0
    Excel Version
    365
    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:
    Click image for larger version. 

Name:	2019-03-30_220108.jpg 
Views:	102 
Size:	13.9 KB 
ID:	9008


    or for the whole pivot table you use Max or Automatic in:
    Click image for larger version. 

Name:	2019-03-30_220159.jpg 
Views:	93 
Size:	13.2 KB 
ID:	9009
    Last edited by p45cal; 2019-03-30 at 11:06 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •