Microsoft KB Archive/249060

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Article ID: 249060

Article Last Modified on 11/13/2003



APPLIES TO

  • Microsoft Excel 2000 Standard Edition
  • Microsoft PowerPoint 2000 Standard Edition
  • Microsoft Word 2000 Standard Edition



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.


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


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 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.

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.

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.


Additional query words: Microsoft PowerPoint can t start the application required to open this object

Keywords: kberrmsg kbbug kbfix KB249060