Hi xld,

Yep, updating the sql in PP via vba isn't possible, so using slicers on all the data until I find a more efficient way.

Came across this article though: http://dmoffat.wordpress.com/2013/08...-excel-2013-2/