Hello

I have a workbook with some data from which I have created a pivot table and a pivot chart.

I wonder if it's possible to create a new workbook and link to the pivot chart, where the pivot chart should update dynamically as more data is added.

The reason for this is that I have some users who are only allowed to see the content of the pivot chart, and I want to save some time not having to send them the chart every week.

Thanks in advance.