Hi All,

I am trying to figure out if there is a way to capture the event when a date range is changed within a timeline slicer.

What I am trying to accomplish is:

- I need to capture the date range change event within the timeline slicer
- have my charts updating data when the date range is changed.

What happens now is that when I change the date range in my timeline slicer the connected pivot tables are updated accordingly and instantaneously but the charts that take data from some fields of these pivot tables (they are not pivot charts) need a save workbook action before they can get updated with new data.

The reason why I am using charts connected to only some of my pivot tables is that they are more customizable than pivot charts.

Thank you in advance for pointing me towards the right direction