Dear Mr. Toby,
Terima kasih atas masukannya, akan ane coba. Salam, DD From: Toby kenzo tobyke...@yahoo.co.id [belajar-excel] [mailto:belajar-excel@yahoogroups.com] Sent: 20 April 2015 22:36 To: belajar-excel@yahoogroups.com Subject: Re: [belajar-excel] Rekap Data dengan VBA Dear Dede, Coba buat module baru, masukan formula: Sub Refresh() Dim pvttbl As PivotTable Dim ws As Worksheet Sheet3.Activate For Each ws In ActiveWorkbook.Worksheets For Each pvttbl In ws.PivotTables pvttbl.RefreshTable Next Next End Sub masukan Assign Macro pada Button Form Control ("Update") It's work in Office 2013 SP1. TerimaKasih. Sent from <http://overview.mail.yahoo.com/mobile/?.src=Android> Yahoo Mail on Android _____ From: Dede pmaho_l...@nabatisnack.co.id [belajar-excel] <belajar-excel@yahoogroups.com>; To: <belajar-excel@yahoogroups.com>; Subject: [belajar-excel] Rekap Data dengan VBA [1 Attachment] Sent: Mon, Apr 20, 2015 8:57:41 AM Dear All Master, Saya punya master file dengan nama “Pivot EPE-OFR Summary”, pada file tersebut ada sheet “DataBase” dimana sheet tersebut rekapan dari file-file lain. Saya beri contoh 2 file seperti terlampir (1000453 dan 1000758). Harapannya adalah pada saat saya klik button “Update”, secara otomatis data merefresh mulai dari kolom C s/d BF. Yang datanya diambil dari file 1000453 dan 1000758. Sebenarnya data file dimulai dari 1000453 s/d 1000758 makanya ini sangat memakan waktu. Mohon pencerahannya. Salam, DD _____ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.