Hi friends,
I need a help in Refreshing the Pivot table using Macro.
In a Excel, there is a Sheet called EPO Compliance, where user will remove all the data and replace it with new data.
Once its done, User will go to Home page and click Refresh Pivot. Once it was clicked, it should replace all the 9 Sheets from EPO - 1 to EPO - 9.
I tried some codings which doesnt work.. Can you please help me.., Those codes which i tried was also in the sheet.