I have a dashboard style workbook with numerous slicers on various sheets which link to pivot tables on those sheets. For some reason I am seeing that when certain users refresh pivots the workbook which is linked to external Access tables as the source, the Report Connections for all of the slicers are unchecked. The question I have is two parts in the sense of- has anyone else seen this happen before/know the cause and how to stop this from happening? The second part would be, if this is an unavoidable glitch for some other reason, is there a snippet of Vba I could add to easily have the workbook on open or link to the refresh macro that would simply loop through all of the slicers on each sheet and "re-check" off all of the Report Connection pivot tables listed?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
