May 27 2020 03:58 AM
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
May 27 2020 06:57 AM