Updating and refreshing data sources


show more Updating and refreshing data sources provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Updating and refreshing data sources

Companies generate new sales, budgetary and operations data all the time, so Pivot Table data sources really remain static. In this lesson, I will show you how to manage your data connection to ensure your Pivot Table contains the most recent data available. You can display your Pivot Table's data connections by clicking any cell on the Pivot Table and then on the PivotTable toolbar clicking the PivotTable Wizard button. In the PivotTable Wizard, click the Back button and here in the Range field you can see the cells from which Excel is drawing its values.

Now let's see what happens if I edit a value in the data source for this Pivot Table. I will click Cancel. And the data source is on Sheet2, so I will go there. The first value in the list is for 2008, Quarter 1, January sales for FirmA. And I will change that value to 10. And press Return. If I go back to the Pivot Table on Sheet1, the value is still 67, but on the PivotTable toolbar, if I click the Refresh button, Excel fil...

Updating and refreshing data sources
Video duration: 2m 33s 1h 7m Intermediate

Viewers:

Updating and refreshing data sources provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...