I have a very large XLS file (150MB) that I use to populate a lot of pivot tables and charts on various worksheets for different things. I would like to export a single sheet which contains one pivot table and one pivot table chart, save the file, then distribute it to the users so that 1. The size is small. 2. All my crazy ways of populating data remain my secret

The problem I am having is after I copy the worksheet itself to a new workbook whenever I change selections in the pivot table the chart no longer updates. The pivot table does.

Does anyone know how I can preserve the pivot table chart as well? If it doesnt update its worthless. I can break down my scenerio to a 400KB file if anyone wants to take a look at it.

Version: Excel 2007.