Simpatie.ro - matrimoniale
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.
Nou pe simpatie:
bella_sexy 25 ani
Femeie
25 ani
Bucuresti
cauta Barbat
27 - 48 ani
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] Refresh Pivot Table in ActiveSheet

Pagini: 1 Moderat de TRaP, TonyTzu
#1
TRaP
Moderator
Postari: 960

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


 
   
Pagini: 1  
Mergi la