Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
Linked Spreadsheets - Preventing Access to Source Sheet | Excel Discussion (Misc queries) | |||
Access to Excel 2007 curious behavior | Excel Discussion (Misc queries) | |||
Excel 2007 - How do I quickly update a chart using Source data? | Charts and Charting in Excel | |||
How to avoid when linked source data is changed, chart turns blan. | Charts and Charting in Excel |