Pivot Table and Last Row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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").Selec
ActiveSheet.PivotTables("PivotTable11").RefreshTabl

End Su

Thanks in advance
Aaron
 
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 here:

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

Then, when you refresh the pivottable, the new data will be included.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Pivot Table Error 1
Refresh data with macro code 0
Playing back a Pivot Table macros 2
Pivot Table VBA question 1
Format Pivot total rows 2
syntax in VBA to create a pivot table 2
Excel 2007 Pivot Tables - Updated Data Source 1
Pivot Tables - refresh from Userform command button 2

Back
Top