Are you trying to refresh the pivottable so it includes new data that
you've added to the source table? You can base the pivot table on a
dynamic range, which will automatically expand to include new items.
There are instructions he

http://www.contextures.com/xlPivot01.html

Then, when you refresh the pivottable, the new data will be included.

Aaron wrote:
I am trying to refresh a Pivot table to the last row in a Macro. Any Ideas?

Here is what I have so far.

Sub Refresh()

Sheets("PivotCharts").Select
ActiveSheet.PivotTables("PivotTable11").RefreshTab le

End Sub


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html