Hi All,
I got code to dynamically change the range of pivot table from one of the external website and below is the code:
The above code is taking source data range dynamically. But the problem is, if I double click on any row field, am getting pop up warning as below:
powarn.jpg
As per the pop up warning, am manually refreshing all the pivot tables as below:
pide.png
After searching over the internet, found that enabling "Save source data with file" from pivot table options --> Data fixes the issue but still I end up with same pop up warning everytime I close and open the workbook.
Pivot table options:
piop.jpg
I will be glad if I get some explanation that though VBA has below line of code to refresh pivot table, why get warning pop up and also possible fix.
It will be helpful if I get fix that works within VBA instead of me doing these settings manually everytime.
Regards,
Richa
Bookmarks