98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel seminar training - Pivot tables
advanced excel seminar training - Pivot tables
Resolved · Low Priority · Version Standard
Thu 20 Sep 2007, 09:56Delegate Dominique said...
Dominique has attended:
Excel Intermediate course
Excel Advanced course
Pivot tables
How do I amend pivot tables without having to create the pivot table again from step 1?
Tue 2 Oct 2007, 11:13Trainer Richard said...
RE: Pivot tables
You can either right click on the PivotTable and choose PIvotTable WIZARD. This will take you back into the steps of the wizard.
Alternatively you can drag the firlds OFF the PivotTable and then recreate the layout.
Tue 2 Oct 2007, 11:55Trainer Amanda said...
RE: Pivot tables
Hi Dominique
Thank you for your question.
Once the pivot table has been created, you can change what is displayed in the table by dragging a field into or out of the table.
To update the data items field, click the Refresh button (!) on the Pivot Table toolbar.
I hope this helps.
Amanda
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using Alt in Save Dialog BoxWhen you are saving (or opening) a file, try these; |
