Hi Dale

You would be very unwise to make your source range the whole columns. It
will slow everything down, especially in XL2007 with 1 million rows.

From a posting I made a couple of days ago


It all depends upon your source data range being Dynamic.
If your source is currently set as $A$1:$M$200 and you then 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

I hope that this helps clarify the issue

--
Regards
Roger Govier

"Dale" wrote in message
...
Thanks! Problem solved.

"smartin" wrote:

Dale wrote:
I created a pivot table in a worksheet. The data for the pivot table
comes
from another worksheet (same book). When I update the worksheet for the
data
the pivot table output doesn't reflect the update. I wouldn't think
that I'd
have to create a new pivot table each time...so I'm hoping that there's
a way
to have the output of the pivot table reflect the updated worksheet.
Thanks.

The pivot table will not pick up new data until you refresh it. Right
click the pivot table and select Refresh Data.

Also, you may have limited the pivot table's source data to the original
range of data -- hence any additional rows of data will not be picked up
when you refresh the pivot table. To correct this, right click the pivot
table, Pivot Table Wizard | Back | update the range appropriately. If
you select full columns at this step you will never need to worry about
the range problem again. Refreshing the pivot table will be necessary
after changing the data range.
.


__________ Information from ESET Smart Security, version of virus
signature database 4539 (20091024) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4539 (20091024) __________

The message was checked by ESET Smart Security.

http://www.eset.com