Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
850
Chapter 30 Using PivotTables and PivotCharts
Refreshing Data in a PivotTable
When you change the layout of a PivotTable, Excel automatically recalculates the resulting
display of data. If you add or edit data in the underlying list, however, your changes do not
appear immediately in the associated PivotTable. For PivotTable reports based on Excel
lists, you must manually refresh the data in the PivotTable whenever you add, remove, or
edit data. To be certain that the PivotTable reflects all recent changes, click the Refresh
Data button on the PivotTable toolbar. If this toolbar isn’t visible, choose Data, Refresh
Data.
30
Figure 30.14
Use the options ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link