Dear Members,
Although the question has been asked several times in the forum. I would like to know if there has been any comprehensive solution. Is recording macro the only option? I have set my pivot to refresh upon opening the workbook as this Excel file is being updated by several parties...