I know this is an old thread, but I just found a solution to this and I've been wrestling with this problem for months now so I wanted to share it:
1.Create a New Workbook
2. Copy the worksheet to the new workbook
(right click: Move or Copy, select create a copy and put it in the new workbook)
3. Change the name of the worksheet to its new name in the new workbook
4. Move the newly named worksheet back to the old workbook
The chart references will point to the data on the newly named worksheet.
|