98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Pivot tables
excel 2003 visual basic intermediate course - Pivot tables
Resolved · Low Priority · Version Standard
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?
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
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:The Easiest and Quickest Way to use Autosum in Excel 2010Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature. |