First, there’s the Single Document Interface (SDI). If you have two linked documents open and you calculate, both documents go into the calculation tree.
That’s where every document is in it’s own application container. So it’s not exactly separate application containers.
If multiple pivot tables are based on the same data source, you can create a slicer, and connect it to one or more of those pivot tables. Selected = False End If Next si Long exit Handler: Application. Enable Events = True Exit Sub err Handler: Msg Box "Could not update pivot table" Resume exit Handler End Sub The final step is to move the slicers -- the short list slicer will go onto the main sheet, beside the original pivot table.
However, if there are pivot tables from different data sources, you can't connect the to the same slicer. The long slicer will go onto the short list sheet, where it will be updated by the code.
With the new encryption scheme, protecting and unprotecting a worksheet in code takes a touch longer. I don’t know what exactly to do about the protection problem.
My code opens templates, unprotects them, writes stuff, combines them into a final report, and reprotects them.
The first thing I did was get stingy about my protection.
You can use programming to control the slicers, and this page has sample code that you can use.
When you select an item in one slicer, it will automatically select the same item in another slicer.
Instead, we'll create another pivot table, with just the short list of cities, and use programming to change the selections in the main slicer.