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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table 1
Pivot Table Help! 1
remove Absolute references when copying from pivot table 4
Pivot Table Filter values 5
Turning Data into a Table 1
not your typical Pivot Table Named Range question 7
Pivot Table selection that will allow Grouped fields to show up ineach cell 1
"Pivot Table" option in Add / Remove buttons for Pivot Table Toolbar 1

Back
Top