Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

This article was previously published under Q316027

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbchart, kbmui, kbxlslink, kbtshoot, kbfix, kbprb, KB316027

↑ Back to the top

Article Info
Article ID : 316027
Revision : 7
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 487