Readdy Write  
0,00 €
Your View Money
Views: Count
Self 20% 0
Your Content 60% 0

Users by Links 0
u1*(Content+Views) 10% 0
Follow-Follower 0
s2*(Income) 5% 0

Count
Followers 0
Login Register as User

Excel vba : Pivot Datenquelle automatisch aktualisieren

07.03.2019 (👁57)

Excel vba : Pivot Datenquelle aktualisieren

Der folgende Code aktualisiert die Daten einer Excel Pivot-Tabelle

pivotTable.RefreshTable

Vba Macro Code

Option Explicit

Sub Tabelle_aktualisieren()

    '--------< Tabelle_aktualisieren() >----

    '< get_Worksheet >

    Dim ws As Worksheet

    Set ws = ActiveSheet

    '</ get_Worksheet >

   

    '< get_Pivottable >

    Dim pvt As PivotTable

    Set pvt = ws.PivotTables(1)

    '</ get_Pivottable >

   

    'refresh

    pvt.RefreshTable

    '--------</ Tabelle_aktualisieren() >----

End Sub