PivotTable

[Guest]

Hi All,

I have a PivotTable and i need to add daily information to my datasheet and
i want to know that how can i refresh the pivotTable with new data.

any help would be appriciated.

Thanks,

 

[Roger Govier]

Hi

Depending upon your version of Excel, there may be different alternatives.
If you are using Excel 2003, then place your cursor in a cell of your data
source>Data>List
This will create a dynamic range which can the be used as the source for the
Pivot Table.

In Excel 2007, again choose a cell in your Data source>Insert tab>Insert
Table.
Again this will give a dynamic table that will be the source for the Pivot
Table.

The following will work for any version of Excel
Insert>Name>Define>
Name MyData
Refers to =OFFSET($A$1,0,0,COUNTA($A;$A),COUNTA($1:$1))

Right click on your Pivot Table>Pivot Wizard>back>Source=MyData

As you add more rows to your source data, they will automatically be
included within the Pivot Table.