Microsoft KB Archive/931377
Article ID: 931377
Article Last Modified on 10/15/2007
- Microsoft Office Excel 2007
You try to copy a worksheet that contains a chart to a new worksheet in the same workbook in Microsoft Office Excel 2007. When you do this, the chart that was copied to the new worksheet continues to refer to the data on the original worksheet instead of to the data on the new worksheet.
This problem occurs because the worksheet name is always included in the series references in a chart. When the worksheet is copied to a new worksheet, a worksheet name conflict occurs.
To work around this problem, copy the worksheet to a new workbook, re-name the worksheet, and then move it back to the original workbook.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Additional query words: XL2007
Keywords: kbtshoot kbprb kbexpertisebeginner KB931377