Pivot Table Will Not Expand Beyond Ten Columns

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have designed a pivot table that I intended to update each month.
My data table includes a column for the date at the monthly level.
Until this month, it was working fine. As each month passed, I would
simply check off the new month in the drop down menu in the pivot
table.

However, for some reason, when I select November, the table does not
expand one column. Instead, the table stays the same size, but drops
March data (though March remains selected in the drop down).

I've never come across this before. Any ideas what I'm doing wrong?
Thanks!
 
Is there still March data in the source data table?

Do you have a Top 10 AutoShow filter on the Month field?
To check, right-click on the Month field button, and click Field Settings
Click Advanced, and for Top 10 AutoShow, select Off.
 
Back
Top