Hi All, I need help to write code to refresh pivot table automatically when source data changes. I have worksheet 'MainData' with source column A:I, I have created button 'Refresh Data' on my Main Page where is pivot table and to this button I need simply code. After each time when I will update my 'MainData' I would like to by the button update my pivot table.
Bookmarks