hi.!

when i add some more data to the existing data how can i update
the pivot table..! when i use the "refresh" option it is of no use..!
any hlp pl..?

-via135

Hi

It all depends upon your source data range being Dynamic.
If your source is currently set as $A$1:$M$200 and you ten add data to rows
201, 202 etc, then Refresh will have no effect, as you have told Excel only
to use data down to row 200.

Different options exist dependent upon the version of Excel you are using.
For XL2003
Place your cursor in the first row of your dataDataListCreatecheck my
List has Headers
Then Place your cursor in the first cell of this List and dataPivot
TableFinish and it will use the List as the source.
The List is Dynamic and will grow as you add more data.

In XL2007
Place cursor in first row of dataInsert tabTablecheck my table has
HeadersGive it a different name if required in the Table Name box of the
Design tab that appears
Place cursor in data tableTable DesignSummarise with Pivot Table.

For any version of Excel, you can create your own Dynamic named ranges.
For more information on this take a look at a tutorial I wrote at
http://www.contextures.com/xlDataVal15.html

If you want your Pivot Table to update automatically, without having to
click the Refresh button, then, assuming your PT is on a different sheet to
the source data, copy this simple code to the PT Sheet.

Private Sub Worksheet_Activate()
ActiveSheet.PivotTables(1).PivotCache.Refresh
End Sub


To USE
Copy code as above
Right click on sheet tab with PTView Code
Paste Code into white pane that appears
Alt+F11 to return to Excel


--
Regards
Roger Govier

"via135" wrote in message
...
hi.!

when i add some more data to the existing data how can i update
the pivot table..! when i use the "refresh" option it is of no use..!
any hlp pl..?

-via135

__________ Information from ESET Smart Security, version of virus
signature database 4533 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4533 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com

On Oct 22, 10:10*pm, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
Hi

It all depends upon your source data range being Dynamic.
If your source is currently set as $A$1:$M$200 and you ten add data to rows
201, 202 etc, then Refresh will have no effect, as you have told Excel only
to use data down to row 200.

Different options exist dependent upon the version of Excel you are using..
For XL2003
Place your cursor in the first row of your dataDataListCreatecheck my
List has Headers
Then Place your cursor in the first cell of this List and dataPivot
TableFinish and it will use the List as the source.
The List is Dynamic and will grow as you add more data.

In XL2007
Place cursor in first row of dataInsert tabTablecheck my table has
HeadersGive it a different name if required in the Table Name box of the
Design tab that appears
Place cursor in data tableTable DesignSummarise with Pivot Table.

For any version of Excel, you can create your own Dynamic named ranges.
For more information on this take a look at a tutorial I wrote athttp://www.contextures.com/xlDataVal15.html

If you want your Pivot Table to update automatically, without having to
click the Refresh button, then, assuming your PT is on a different sheet to
the source data, copy this simple code to the PT Sheet.

Private Sub Worksheet_Activate()
ActiveSheet.PivotTables(1).PivotCache.Refresh
End Sub

To USE
Copy code as above
Right click on sheet tab with PTView Code
Paste Code into white pane that appears
Alt+F11 to return to Excel

--
Regards
Roger Govier

"via135" wrote in message

...



hi.!

when i add some more data to the existing data how can i update
the pivot table..! when i use the "refresh" option it is of no use..!
any hlp pl..?

-via135

__________ Information from ESET Smart Security, version of virus
signature database 4533 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4533 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com

thks roger..!
i got it..!

thks again..!

-via135