Why is Pivot not adding new columns?

TJones Hoshizaki

I have several pivot tables that are linked to a sales database. The pivot columns based on the month. The issue I'm having is as the database grows and sales for the next month are added to the database the pivot table is not adding the new month column. How do I fix this?

Mark Cronk

Hi @TJones Hoshizaki ,

Check the update settings in your pivot table. Make sure it's not sett to never; which then requires a manual update. Try doing a manual update and see if that refreshes the data for you.

Good luck.

Mark

Mark Cronk

Hi @TJones Hoshizaki ,

Check the update settings in your pivot table. Make sure it's not sett to never; which then requires a manual update. Try doing a manual update and see if that refreshes the data for you.

Good luck.

Mark