A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Odd Excel 2007 behavior: copied chart linked to source sheet



 
 
Thread Tools Display Modes
  #1  
Old January 8th 08, 07:30 PM posted to microsoft.public.excel.charting
dparizo
external usenet poster
 
Posts: 6
Default Odd Excel 2007 behavior: copied chart linked to source sheet

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
Ads
  #2  
Old January 9th 08, 06:58 PM posted to microsoft.public.excel.charting
MikeM_work
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

  #3  
Old January 9th 08, 07:59 PM posted to microsoft.public.excel.charting
dparizo
external usenet poster
 
Posts: 6
Default Odd Excel 2007 behavior: copied chart linked to source sheet

Great answer, and thanks for the link Mike!

"MikeM_work" wrote:

> 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

  #4  
Old January 10th 08, 02:15 AM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 6,582
Default Odd Excel 2007 behavior: copied chart linked to source sheet

This was unfortunately introduced in 2007, because it works as expected in
earlier versions.

Another way around it, if you're going to use a particular sheet and its
chart frequently, is to copy the sheet to another workbook, then save the
new workbook as a template. Whenever you need a copy of the sheet, right
click on a sheet tab, and select this template to insert a new sheet based
on the template.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MikeM_work" > wrote in message
...
> 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



  #5  
Old February 16th 10, 07:31 PM posted to microsoft.public.excel.charting
Doug_F
external usenet poster
 
Posts: 13
Default Odd Excel 2007 behavior: copied chart linked to source sheet

Not sure if this is related, but we have found the following (slightly
different issue).
Tab has data and a chart linked to the data.
Use 'copy/Move' to clone the tab.
If Excel is at SP2, the new cloned tab's chart points to the cloned data.
If it's not at SP2, the new cloned tab's chart points to the original tab.

Big fun!

"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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying linked data in excel 2007 when linked file is not avail Eng_19 Excel Discussion (Misc queries) 0 December 7th 07 07:27 PM
Linked Spreadsheets - Preventing Access to Source Sheet [email protected] Excel Discussion (Misc queries) 1 March 16th 07 02:29 PM
Access to Excel 2007 curious behavior artificial Excel Discussion (Misc queries) 0 February 6th 07 05:41 PM
Excel 2007 - How do I quickly update a chart using Source data? SWODoug Charts and Charting in Excel 2 June 12th 06 09:31 PM
How to avoid when linked source data is changed, chart turns blan. Chris S (Belgium) Charts and Charting in Excel 0 March 9th 06 01:10 PM


All times are GMT +1. The time now is 08:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.