Slicers and Mixed data - Pivot and tables

Looking for help

Have a multi sheet excel file with 3 + tables of data. For each table they have a similar column (Manager)

Have created 3 Pivot tables and for ease of use linked the slicers to the Pivots

A Manager comes in to a summary page - select their own name from 1 slicer - and each of the 3 pivots displays data about their team members nicely formatted

All works well. The single Excel file is shared via one drive - and I want each Manager to access the file, select themself and check the team members data is correct
(Privacy issues are not a concern around the data - so if someone selects someone else its ok - no issue)

On the summary page - I have a table of Managers names (to also be filtered) that allows the manager to tick off 3 columns of actions (1 per sheet)
i.e I checked Pivot 1 - all ok, I checked pivot 2 - all ok, I checked pivot 3 - it needs some data changes !

I thought I could connect the 1 slicer to the data entry table - but am unable to - any ideas would be helpful ?

As a separate option (marking pivot data for amendment) is there a way to on the same set of 3 pivot tables - have the Managers add comments against some of their rows ?
I can have them color a cell - and it sticks in the pivot data

If I add a Note or a comment - it sticks to the underlying cell

And I cant see where you can append comments to a row in the pivot

Hope this makes sense

Please attach sample workbook.

Attached file as an example - I want the summary to show pivot data and access the tracker to complete details for the person

Use the Name field in Managers table in place of the Regional Manager field in PivotTables PivotStates and PivotFacilities.

To link slices in PivotTables and Excel tables, you need to do it with VBA.

Check out the VBA codes here: https://stackoverflow.com/questions/...icers-in-excel

Thanks

So after a lot of trial & error a couple of things learnt :

1. A pivot table without a "value" column is not recognised by the slicers report connections correctly !
I had 2 pivot tables where I was looking at just the row data - show the users a few elements of the structure - no calculated values
Whenever I tried to get a single slicer to connect - it only worked on the 1 pivot it was created against

If I added a value to the pivot design - bingo all worked - could connect 1 slicer to multiple pivots

2. Needed to make some changes to get the VBA macro to use the Pivot slicer selections and update the Table Slicer selections
On my O365 version of excel - it seems the object model is different depending on which slicer you are processing

So for the pivot slicer - to read the values I need to use .SlicerCacheLevels(1).SlicerItems

Then for setting values on the table slicer - needed to use [Table Slicercache].VisibleSlicerItems([sliceritem].Value).Selected = [sliceritem].Selected

Please review the attached macro enabled excel