View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
MikeM_work MikeM_work is offline
external usenet poster
 
Posts: 9
Default Odd Excel 2007 behavior: copied chart linked to source sheet

Doug:
I found the same behavior: when copying a worksheet containing a chart
object, the chart on the new worksheet continued to be sourced back to the
original worksheet. This is a real difficulty when re-sourcing complex,
custom charts.

Check this out from the MS Knowledge Base:

http://support.microsoft.com/kb/931377/en-us

It's definitely a bug; they're working on it... at least there's a workaround.

"dparizo" wrote:

Hi all,

I'm finding that Excel 2007 has a strange behavior when it comes to copying
sheets that contain Pivot Tables & Pivot Charts.

Let's say that on Worksheet A, I have a Pivot Table A and Pivot Chart A that
is linked to it. If I change Pivot Table A, Pivot Chart A will change to
reflect. So far, so good.

Now, let's say I COPY Worksheet A to Worksheet B. Now I have Pivot Table B
and Pivot Chart B on the new worksheet.

Problem: Pivot Chart B is STILL LINKED to Pivot Table A! If I change Pivot
Table A, both charts change! If I change Pivot Chart B, neither chart
changes.

This is new in Excel 2007, and it's a huge annoyance for me, as I create
hundreds of charts by copying worksheets.

Anyone know a way to get Excel 2007 to behave like Excel 2003 on this one?
Thanks!

Doug