Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - 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. |
excel 2003 visual basic intermediate course - Pivot tables
Resolved · Low Priority · Version Standard
Reply Fri 25 Jan 2008, 14:00Delegate Rica said...
Rica has attended:
Excel Advanced course
Pivot tables
If I create a pivot table using database from month-end, the following month, can I overlay new data so that the table simply refreshes? Or will excel just freak out with the new data?
For upcoming training course dates see: Pricing & availability
RE: Pivot tables
Hi Rita
Thank you for your question.
The data range that you use to create the pivot table can have changes made to it which can then be shown in the pivot table.
You can try this out, if you create a pivot table, then make changes to some of the figures within the data range that the pivot table is created from.
To update the pivot table data, you can either right-click in the pivot table area and choose Refresh, or use the Refresh (!) button on the Pivot Table toolbar.
This will overwrite the 'old' data with the current data from the data range which the pivot table is constructed from.
I hope this helps.
Amanda
Reply Mon 11 Feb 2008, 16:46Delegate Rica said...
RE: Pivot tables
Thanks, Amanda!
|