How to update datasources of a pivot table ?

G

Guest

Hi everyone !

My database is changing everyday (adding and removing of lines)
I've got some pivot tables linked with this database in the same workbook.

I want the VBA code to update the datasource range for my pivot table.

I've wrote this code but I can't understand why it is not the main pivot
table that's updating but another one is created bottom side. this last one
has got the updated datasource.

Thanks to help me !!!

'Sheets(tab1).PivotTableWizard SourceType:=xlDatabase,
SourceData:=Sheets("databasis").Range("A17:BJ" &
Sheets("DataBasis").UsedRange.Rows.Count),
TableDestination:=Sheets(tab1).Range("A3")
'Sheets(tab1).PivotTables("Tableau croisé dynamique1").PivotCache.Refresh
 

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

Playing back a Pivot Table macros 2
Pivot Table Macro with dynamic source data 1
Pivot table code question 2
Pivot table in VB 3
Build Pivot Table with VBA; Keeps Throwing an Error 1
Macro to update pivot table data range 3
Pivot Table 1
VBA for pivot tables 2

Top