How to duplicate or make copies of your pivot table. Make multiple pivot tables quickly.

If you have to create 7 pivot tables from the same data source, don't sit and create them separately from scratch. Simply make copies or duplicate them.

After this video, to learn in-depth about Pivot tables and charts, Enroll for an Online course conducted by me on Master Business Reporting with Pivot tables and charts in Excel

Also, as you are a special Viewer/ Subscriber,
we would like to give out a special discount just for you,

SUBSCRIBE NOW!

Click this link to learn more awesome functions in Excel

Click this link to learn how to manage your personal finance using Excel

[omarsaeed]

your two minutes video clip is more valuable than one hour from other channels. thanks

[ashwinantony]

I used to create separate pivots, never knew the copy-paste would work on pivots. Thanks, Great help indeed.

[raf]

I swear you’re videos are the most helpful ever and straight to the point, I can’t thank you enough for making my seek for info a lot easier, thank you so much, keep it up 🙏

[BelalC]

I can’t believe it’s this simple. Thank you!

[zilla]

So easy to follow and understand. THANK YOU

[chandramohan]

What, I thought I should take 1year course for this 😂. So simple

[EYEmaginary]

When I copy and paste, the new table's filters and fields are linked to the first one. This means when changing the rows in one table, it also changes in the second. How to prevent this?

[ambulanche]

The copy-paste don't work on my office Excel...

[pipo]

I have one data set. I have several pivot tables. Now I want to combine data from two pivot table (using specific filters to each) and now have a calculated field in the new pivot table. Any suggestions?

[sridharsuga]

Sir simply awesome thank u so much....

[osPA]

So simple but thank you for putting this video together!

[jaredbrabham]

When I do this the table does not copy just the values?

[Prisley]

Since they are coming from the same data source, do all pivot tables will get refresh if i refresh one of them?

[Lannd]

i wish there was still a more simple way to make this.

[mohitdhanjani]

I want to apply those 7 tables In same manner to data sets(same headings, data type) in different workbook how to make that short as much as possible