Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel seminar training - Pivot tables
|
|
|
The UK's most regular 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. |
advanced excel seminar training - Pivot tables
Resolved · Low Priority · Version Standard
Reply 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?
For upcoming training course dates see: Pricing & availability
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.
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
|