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:
luana_21
Femeie
21 ani
Prahova
cauta Barbat
21 - 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: 787

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 2 ani
   
Pagini: 1  

Mergi la