Pivot table chart will not update after copying worksheet to a new workbook

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.

In my source file the pivot table source is a named range. I then named the pivot table and confirmed the charts souce is the pivot table on the same sheet.

I have played with it a bit more and have discovered that the chart in the copied worksheet changes to just a normal chart. There is no reference to it being a pivot table chart. If I then create a new chart in the copied workbook it will do a pivot table chart again.

I don't understand why it would go from a pivot chart to a regular chart by simply copying the worksheet into a new workbook.

I have tried both excel 2007 and 2010 both of which behave the same. Anymore ideas?

Well, i added a new chart and then copied it out to a new workbook and the new chart works, original still doesnt.

I gave up trying to fix the first one and re-created the chart. Terrible waste of time!