• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Muliti Pivots on one work sheet

bobhc

bobhc

Excel Ninja
Morning

Busy day at work creating pivot tables, seem to be getting the hang of the basics but have a problem I can not find the answer to so here I am again

So, in Office 2010 I am having issues when I create multiple pivot tables with the same data source. I want to be able to control each independently, but instead, when I make certain changes to one table, it is effects the others as well. For example, when I change the data field in one table, it will make that change across all pivot tables...very frustrating..

I create the pivot tables in one sheet then copy and paste in to another so that I can present just one work sheet to the management


Are they linked? How do I stop this from happening?
 
If you are making changes to the base data i.e the data from where the pivot pickup the information all the pivot tables will be affected as the base data is changed. If you do changes in one pivot table it does not affect the data in the 2nd pivot table, as the pivots are not linked to each other.
 
I select the data from the work sheet and then follow recommendation of pivot table to use new work sheet. I then set up the new pivot table with the data I want and then copy to a new sheet, I go back to original pivot table alter the data and copy to the graph sheet, I do this until I have separate pivot tables on one sheet(graphs)

But if I change the data in the original or a graph on the graph sheet all tables update to the changes!!
 
While copy pasting the data from pivot to new sheet please do paste special values...


Excel 07 or 10 - Home - paste (below there should be an arrow) - paste special - values.

Excel 03 - Edit - paste special - values.


shourtcut - Alt E+S+V (after copy)
 
I am in office, maybe you can share a sample file...someone would surely assist you...


http://chandoo.org/forums/topic/posting-a-sample-workbook
 
You must log in or register to reply here.
Back
Top