Pivot Table Change Data Source not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1420145%22%20slang%3D%22en-US%22%3EPivot%20Table%20Change%20Data%20Source%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1420145%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20recently%20been%20experiencing%20what%20must%20be%20a%20bug%20in%20Excel%20where%20I%20try%20and%20change%20the%20data%20source%20of%20a%20pivot%20table%2C%20but%20nothing%20happens%20and%20it%20just%20stays%20as%20the%20same%20old%20data%20source.%20It%20only%20happens%20when%20I%20have%20two%2Fmultiple%20pivot%20tables%20using%20the%20same%20data%20source.%20So%20I%20think%20it%20must%20be%20an%20issue%20with%20how%20my%20Excel%20is%20dealing%20with%20pivot%20table%20caches.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20only%20started%20happening%20recently%20and%20was%20not%20always%20a%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20the%20fix%20for%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBenji%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1420145%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1420551%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Change%20Data%20Source%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1420551%22%20slang%3D%22en-US%22%3EMultiple%20Pivot%20table%20can%20access%20to%20the%20same%20data%20source%20without%20any%20problem.%3CBR%20%2F%3EI%20generally%20face%20such%20issue%20when%20I%20try%20to%20move%20the%20file%20to%20some%20other%20folder%20or%20if%20I%20open%20it%20in%20some%20other%20system.%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply
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.