Hi,
I need to synchronize two slicercaches from two different pivot tables. My first approach would be this:
For Each s_item In s_cache1.SlicerItems
If s_cache1.SlicerItems(s_item.Name).HasData = True Then
s_cache2.SlicerItems(s_item.Name).Selected = True
Else
s_cache2.SlicerItems(s_item.Name).Selected = False
End If
'Next s_item_cliente
This code runs perfectly well. The problem is that it is a bit slow, even using when disabling calculation, events and screenupdating.
Is there any faster way to accomplish this?
Thanks
Bookmarks