Linking to pivot chart

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.

try creating a new spreadsheet with a pivot table that uses an external data source where the data source is the spreadsheet that contains the data.