Excel 2007 - Local Cube - Pivot Table
 

I have created a PivotTable that queries a local cube file.
This .cub file (Analysis Services 2008) is updated every week
The structure remains the same.But when I replace the old
..cub file with the new one the refresh fails.

Any idea on how to update the pivottable data with
the new file's figures?