Why is Pivot not adding new columns?

Options
TJones Hoshizaki
TJones Hoshizaki ✭✭
edited 06/14/22 in Add Ons and Integrations

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?

· Share on FacebookShare on Twitter

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

    · Share on FacebookShare on Twitter

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video