pivot table not getting refreshed - 2007 excel

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.

Hi,

Pivot may getting refreshed but due to values remains same , you may not be able to determine. anyway add manually random values and do refresh. a nd see changes.

There is an option in Pivot which automatically refreshed all pivot table when excel files is getting opened.
PivotOption-->Data (label)--> Check on Refresh data when opening the file.