Pivot table

  • Thread starter Thread starter Ritchie
  • Start date Start date
R

Ritchie

I'v copied a pivot table from a spreadsheet with last
year's data and put it in a new workbook. Now I want to
update so that the pivot tables uses this year's data?
I'm not having much luck. Can this be done? Any ideas on
how to this would be great. Thanks...
 
Select a cell in the pivot table
From the pivot toolbar, choose PivotTable>Wizard
Click the Back button
Select the cells that contain the current year's data
Click Finish
 
Back
Top