update pivot table

[carol_g_1990]

Hello,

I have 3 pivot tables from diferent origenes. I would like to update each one when I select some filter in the slicer (?). How can I do it? all of them has 2 fields in common, "Service" and "Date". I want that, when I select, for example, "Print" or "Navigation" service (or both), the other pivot tables update their information automatically.
Thanks in advance.

Regards.

 

[gruntingmonkey]

Under the options toolbar there is a refresh all button if you want to do it manually.
If you want to do it in code then use the feature

ActiveWorkbook.RefreshAll

 

[carol_g_1990]

Under the options toolbar there is a refresh all button if you want to do it manually.
If you want to do it in code then use the feature

ActiveWorkbook.RefreshAll

Well, I was thinking in other thing, I copy my code:

Sub Macro1()
'
' Macro1 Macro
'
'

Dim slItem As SlicerItem
Dim i As Long
Dim service As String


applcation.ScreenUpdating = False

With ActiveWorkbook.SlicerCaches("SegmentaciónDeDatos_Servicio1")
For i = 1 To .SlicerItems.Count
If .SlicerItems(i).Selected Then
service = .SlicerItems(i).Name
ActiveWorkbook.SlicerCaches ("SegmentaciónDeDatos_Servicio")
.VisibleSlicerItemsList = Array("[SLA].[Servicio].&[" & service & "]")

Next i
End With

Application.ScreenUpdating = True
End Sub

I want, when I select one o severals Items from "SegmentaciónDeDatos_Servicio1", the slicer "SegmentaciónDeDatos_Servicio" update it information.

My code doesn't work Any idea what can I do?

Regards.

 

[gruntingmonkey]

I cant quite understand what your code is doing or what you are actually trying to do.

 

[carol_g_1990]

Hello,

I have 3 pivot tables from diferent origenes. I would like to update each one when I select some filter in the slicer (?). How can I do it? all of them has 2 fields in common, "Service" and "Date". I want that, when I select, for example, "Print" or "Navigation" service (or both), the other pivot tables update their information automatically.
Thanks in advance.

Regards.

In the following link I attach an example about what I want to do. I want that: when I click on "Month" Slider at the top, the "month" slider at the bottom update with the same option

https://www.dropbox.com/s/v3983a4ut04uyx5/example.xlsx?dl=0

There is any option to syncronize both slider?

Regards.