Bagaimana cara membuat pivot table dinamis yang otomatis memperbarui data setiap kali data sumber diubah?
liakarin552 Answered question February 3, 2025
Pakai Named Range (Dinamis)
- Buka Formula > Name Manager > New
- Kasih nama (misal
DataPenjualan)
Auto-Refresh Pivot Table pakai VBA
Kalau mau otomatis tanpa klik refresh, masuk VBA (Alt + F11) dan taruh kode ini di ThisWorkbook:
Private Sub Workbook_Open()
ThisWorkbook.RefreshAll
End Sub
liakarin552 Answered question February 3, 2025