Linked Excel charts in Office documents do not update after you change MUI Language (316027)


The information in this article applies to:

  • Microsoft Excel 2002
  • Microsoft Excel 2000
  • Microsoft Office 2003, All Editions
  • Microsoft Office XP
  • Microsoft Office 2000
  • Microsoft PowerPoint 2002
  • Microsoft PowerPoint 2000
  • Microsoft Word 2000
  • Microsoft Word 2002
  • Microsoft Office 2000 with MultiLanguage Pack
  • Microsoft Office XP Multilingual User Interface Pack
This article was previously published under Q316027

SYMPTOMS

When you link a Microsoft Excel Chart object to a Microsoft Office document, and then change the default language for Microsoft Office by using a MultiLanguage User Interface Pack, the links no longer update.

CAUSE

When you link to Chart objects, Microsoft Office creates a link that is named with both the sheet name and object name.

Although the sheet names do not change when you change the interface language, the name for the chart object is language-dependent. When you change the interface language, the link still refers to the object name in the language in which the link was created. However, the object name has changed to the new language, so you cannot update the link.

This problem also occurs if you create the files while a language pack is applied, and then you switch to English or to another language.

WORKAROUND

To work around this problem, follow these steps before you create the link:
  1. Open your workbook in Microsoft Excel.
  2. If the Drawing toolbar is not displayed, right-click on any toolbar and then click Drawing to display the toolbar.
  3. Click the Select Objects button on the Drawing toolbar. Then, click outside the chart and drag a bounding outline around the chart to select it.
  4. Click in the Name box in the upper-left corner of the program window.
  5. Type a new name for the chart, and then press ENTER. After you rename the chart, click to clear the Select Objects check box on the Drawing toolbar.
  6. Select the chart, and then copy and paste the link into your Office document.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MinorLast Reviewed:1/6/2006
Keywords:kbchart kbmui kbxlslink kbtshoot kbfix kbprb KB316027
©2004 Microsoft Corporation. All rights reserved.