EXCEL Refresh Pivot Table in ActiveSheet

Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.

Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat.

Nou pe simpatie:
crazylife

Femeie
25 ani
Bucuresti
cauta Barbat
25 - 47 ani

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Refresh Pivot Table in ActiveSheet

Moderat de TRaP, TonyTzu

Autor

Mesaj

Pagini: 1

TRaP
Moderator

Inregistrat: acum 6 ani
Postari: 746

Sub PIVOT_Refresh()
Application.ScreenUpdating = False

' IN CASE YOU WANT TO SELECT THE PIVOT TABLE YOU WANT TO REFRESH (CLICK INSIDE IT FIRST)
'Dim pt As PivotTable
'Set pt = ActiveCell.PivotTable
' pt.PivotCache.Refresh

ActiveSheet.PivotTables(1).PivotCache.Refresh

Application.ScreenUpdating = True
End Sub

pus acum 1 an

Pagini: 1

Mergi la