Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot tables

Resolved · Low Priority · Version 2010

Reply Thu 29 Sep 2011, 12:44Delegate Maria said...

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

For upcoming training course dates see: Pricing & availability

Reply Fri 30 Sep 2011, 14:47Trainer Mark said...

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

Thu 6 Oct 2011: Automatically marked as resolved.

Excel articles

· Flexible uses for Excel at Home
· Charting Another Dimension With Excel
· Microsoft Excel provides the building blocks of shared information
· Using Headers And Footers In Excel 2010
· Microsoft Excel Courses Teach Advanced Macro Techniques

Please browse our web site to find out more about
microsoft.excel.training and other Microsoft training courses.

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips