• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 18. Working with Pivot Tables > Working with Pivot Table Reports

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 place in the COLUMN area into the ROW area. Excel will automatically reformat the pivot table, reflecting the new information. You don't have to use the PivotTable Wizard dialog box here. Just make the change in the pivot table directly.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint