Pivot Table Change Data Source not working

[benji-kj_08]

Hi,

I have recently been experiencing what must be a bug in Excel where I try and change the data source of a pivot table, but nothing happens and it just stays as the same old data source. It only happens when I have two/multiple pivot tables using the same data source. So I think it must be an issue with how my Excel is dealing with pivot table caches.

It only started happening recently and was not always a problem.

Does anyone know the fix for this?

Thanks

Benji

[#2]

Multiple Pivot table can access to the same data source without any problem.
I generally face such issue when I try to move the file to some other folder or if I open it in some other system.