Share via

Changing Pivot data source header while keeping the Pivot alive

Anonymous
2016-10-21T08:25:27+00:00

Hi,

I have a spreadsheet with a lot of columns named like month-year (Jan-2016) reflected to multiple pivots on other worksheets. Every year I have to change the year in the column names, which then stops all the pivots from working and I have to rebuild all of them.

Any workaround on this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-10-22T08:11:59+00:00

    Hi,

    I would suggest to rebuilt your source data table

    with static Name-Headers

    also,

    add an extra column named: 'MONTH-YEAR'

    and type in this column

    jan-2016

    feb-2016

    as text string

    then rebuilt the pivot table as your needs.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-10-22T07:44:05+00:00

    Hi,

    For Excel inquiries, please post your questions to this link.

    You will need to select Community> Forums> View All > Type in "Excel", then select the appropriate category.

    Thank you.

    Was this answer helpful?

    0 comments