Hi All

Is it possible to create a copy of a pivot chart and paste it into a new workbook but still keep the links to the source data. As i am trying to create a seperate report that will copy all of my pivot charts and create a report where people can view them all in one place with out the source data as it makes the document to large but can still refresh the data and change what is shown in them?


Thanks

JR