Hi all,

I have a a excel file which has pivot tables in 5 worksheets.
I open this file via another workbook by vba. And save as the file in another path
And I do refreshall.
But pivot table is not geting refreshed. Even when I tried manualy clicking on refresh all button.
Refresh is not working
Please help me.