Share via

Multiple pivots - changing data sources

Anonymous
2018-10-25T20:35:45+00:00

Hi Team,

I mainrain an excel file with multiple pivot tables and egeryrime its required to change data source in each pivot.

Is thsre a simpler solution?

Am not a techie and may not use the vb option if the same is difficult.

Please help

Regards,

Jambukeswaran N

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

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-10-25T21:06:03+00:00

    Your Excel won't break.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-10-25T21:04:44+00:00

    So, i already have a sheet where i have used merely the = of the pivot sheet.

    If i change the data label (row/column) to does not equal blank and then change the data source in all pivots my excel shouldn't break. Right?

    Thanks and thanks in  advance

    Was this answer helpful?

    0 comments
  3. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-10-25T20:54:41+00:00

    If you choose full column reference, then yes.

    Otherwise you can use Structure Table approach also which is the easiest approach.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-10-25T20:51:57+00:00

    Visualized it and seems okay. Will check this out later in the day and xondiem. Thanks.

    The key here is the does not equal in labels. Thanks

    Was this answer helpful?

    0 comments
  5. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-10-25T20:39:46+00:00

    You will need to create dynamic pivot tables so that you don't need to change data source.

    I have written a blog article on this. You will be able to understand the concepts and various ways to make this.

    Article 46 - Creating Pivot Table with Dynamic Range - http://eforexcel.com/wp/article-46-creating-piv...

    Disclaimer - This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    Was this answer helpful?

    0 comments