The process is something like this :
Each time after a user click an item in the slicer,
there is a running code to write some text below the pivot-table grand total, as I use 
Please Login or Register  to view this content.
After clicking the item in the slicer,
if the total rows of the pivot table "shrink", I don't find a problem.
The problem exists when the total rows of the pivot table "grow"...
because the condition before there is a text below the grand total,
it give me an alert : "do you want to replace the contents of the destination cell in bla3x ?"

So far I've tried :
Please Login or Register  to view this content.
Hoping that clicking the item in the slicer will trigger the "PivotTableBeforeAllocateChanges" first, then trigger the "PivotTableUpdate"...
But it doesn't work. It directly trigger the "PivotTableUpdate" without triggering the "PivotTableBeforeAllocateChanges" first.

I found this code in the internet to suppress the alert
Please Login or Register  to view this content.
but then I don't know where to put the code as the "write some texts below grand total" runs via the slicer and then the private sub worksheet "PivotTableUpdate"

I wonder how do I solve this situation.
Any kind of respond would be greatly appreciated.
Thank you in advanced.