Hi, would there be a workaround for this dilemma - I have a pivot-table with a list of customers. To this table I attach a slicer showing the customers names. All work fine when selecting the client name from the slicer - but in certain cases it is easier to filter the pivot itself - and in such cases the slicer is not updated. Or well yes if I manually scroll to the client name I can see it is marked but why does the slicer show other clients names even if I have the "hide items with no data" checked?
Any ideas how to get the slicer to automatically "scroll to" and highlight the customer that is filtered directly via the pivot table itself? Alternatively hide all other "not selected" clients?
Thankfull for any help or tips and ideas..
Hakan
Any ideas how to get the slicer to automatically "scroll to" and highlight the customer that is filtered directly via the pivot table itself? Alternatively hide all other "not selected" clients?
Thankfull for any help or tips and ideas..
Hakan
