Hi,
I have created a dashboard using a table from an external data source and pivot tables which works fine, however, when I add a slicer to allow me to select the data by month the pivot tables don't refresh unless I unselect and then reselect the months on the slicer.
Any help would be greatly appreciated.