Help and Support
 

powered byLive Search

XL2000: Linking Charts Does Not Work Correctly If Name Has More Than 64 Characters

Article ID:249060
Last Review:November 13, 2003
Revision:3.0
This article was previously published under Q249060

SYMPTOMS

In Microsoft PowerPoint 2000 or Microsoft Word 2000, when you link to a chart object created in Microsoft Excel 2000, you may experience the following problems.

Microsoft Word 2000

When you paste the chart as a link in a Word 2000 document, you receive the following error message:
Word cannot obtain the data for the Microsoft Excel Chart Link

Microsoft PowerPoint 2000

When you double-click the linked, embedded chart in PowerPoint 2000, you receive the following error message:
Microsoft PowerPoint can't start the application required to open this object. An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now?
If you click Yes, the Detect and Repair feature starts.

If you click No, you receive the following error message:
The server application, source file, or item can't be found or, returned an unknown error. You may need to reinstall the server application.
NOTE: Running Detect and Repair or reinstalling Excel 2000 does not correct this problem.
When you open a PowerPoint 2000 presentation that contains a linked, embedded chart and you attempt to update the links when prompted, you receive the following error message:
Some linked files were unavailable and can't be updated. You might be able to re-establish them using the Links command on the Edit menu.
When you attempt to update the link using the Links command on the Edit menu, you receive the following error message:
The linked file was unavailable and can't be updated.

Back to the top

CAUSE

This error message occurs when the path to the file that contains the embedded chart object (including the workbook name, worksheet name and chart object name) exceeds 64 characters. This limitation includes three characters representing the drive, the characters in folder names, the backslash character between folders, and the characters in the file name.

For example, the path for a file might be:
'c:\excel\personal\...\[my workbook with a really long name.xls]up_to_31_char_sheetname'!ChartObjectName

Back to the top

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:
245025 (http://support.microsoft.com/kb/245025/EN-US/) OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
To temporarily work around this problem, rename the workbook, worksheet, or chart object so that they have shorter names.

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

Back to the top

MORE INFORMATION

When you embed an Excel object, the full link path created in the target file usually consists of the following parts:
The full path to the source Excel workbook if it is in a different directory

The characters that make up the source Excel workbook name

An exclamation point that is inserted automatically to separate the Excel file name from the worksheet name

The characters that make up the worksheet name

Any apostrophes and brackets that are inserted automatically to denote the workbook name

The chart object name.
The total length of these combined parts is limited to 64 characters.

Back to the top


APPLIES TO
Microsoft Excel 2000 Standard Edition
Microsoft PowerPoint 2000 Standard Edition
Microsoft Word 2000 Standard Edition

Back to the top

Keywords: 
kberrmsg kbbug kbfix KB249060

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.