Forum Discussion

benji-kj_08's avatar
benji-kj_08
Copper Contributor
May 27, 2020

Pivot Table Change Data Source not working

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

excel

1 Reply

  • bhushan_z's avatar
    bhushan_z
    Iron Contributor
    May 27, 2020
    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.

Resources