Pivot Table and live update

  • Thread starter Thread starter Dries
  • Start date Start date
D

Dries

Hi,

is it possible to have a Pivot Table refreshed as soon as
I
add some data in the datasheet the Pivot Table is based
on and leave this datasheet?

Thx for your help,
Dries.
 
This macro will help.


Private Sub Worksheet_Activate()
Worksheets("Base").Range("cellule").CurrentRegion.Name
= "cellule"
ActiveSheet.PivotTableWizard SourceType:=xlDatabase,
SourceData:="cellule"
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
End Sub


Michel Ngalula
E-mail:[email protected]
 
Hi

thx for your help - are there any parameters to change as
there are different Pivot Tables I'm using (up to 6, in
different sheets); as well as "Base" and "cellule", I'm
using a English version - I suppose I have to change them?

Br,
Dries.
 
Back
Top