Working with Pivot Table Reports
Excel doesn't allow you to edit data in a pivot table report, because it maintains a link to the source data. But you can update the source file to pass any new or changed information to the pivot table. For example, any new clients will show up on the pivot table if you enter them into the source Excel list on the worksheet. After you change the source data, click the Refresh External Data button on the PivotTable toolbar. Excel returns any new or changed information to your table.
What if you want to change the orientation of the table? No problem. Just drag the field button to the new location. For instance, if you want to see the Month data in a row instead of a column, drag the Month field button from its ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
