Maria has attended:
Excel Intermediate course
Pivot tables
Hi,
I created one pivot table with a full data set. Then I wanted to create graphs based on only part of that data set. I copied the table to another tab and there hid some metrics so that only the ones I needed for that graph would show. However, when I did that the original pivot table on my other spreadsheet changed.
When does an original pivot table change and what can I do for it to stay the same?
Thanks,
Maria
RE: Pivot tables
Hello Maria,
Not sure if this is what you require, but could you not just select the data you need from the pivot table, copy, then paste values onto another sheet? Do not do a regular paste! So paste values. However this will not update if your original pivot changes.
If you do want them to update if the original changes, then do a Paste Link, not a Paste Value.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
