Microsoft Office Tutorials and References
In Depth Information
Adding New Records to a PivotTable
Well, the first thing to understand is that, unlike Excel formulas, PivotTables do not
perform automatic recalculation. That is, if you change data in your database, the
PivotTable will not immediately incorporate the changes and update existing results. You’ll
have to refresh the PivotTable instead, by clicking the Refresh button on the Options tab.
To see this, click back into the Salesperson database and change Davolio’s sales
amount to $2,000. Then click anywhere in the PivotTable and click the Refresh button.
You’ll see the new data, as shown in Figure 8–37.
Figure 8–37. Davolio’s sales total has now changed from the original $1614.88.
If you’ve modified an existing record—that is, one already in the database—all you need
to do is click Refresh. But if you’ve added a completely new record, clicking the Refresh
button won’t update the PivotTable. The next section discusses what to do in this case.
Adding New Records to a PivotTable
The easiest way out of this little dilemma is to convert the database into a table. New
table records are automatically processed by PivotTables, and clicking Refresh will then
update your results. Let’s try it.
1.
First, click anywhere in the database, click the Insert tab and choose
Table from the Tables button group, and then click OK.
2.
Then add a new record containing the information shown in Figure 8–38.
Figure 8–38. New recruit: Walters joins the sales force
3.
Click Refresh. Walters’ data will be automatically incorporated into the
PivotTable, as shown in Figure 8–39.
 
Search JabSto ::




Custom Search