WD: Cannot Convert Microsoft Excel Worksheet Object to Chart

This article was previously published under Q120773
This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
In Word for Windows, when you try to convert an embedded Microsoft Excelworksheet object to a Microsoft Excel chart, the worksheet is notactually converted.
CAUSE
"Microsoft Excel Chart," which appears as an option in the Convertdialog box, is not a valid choice. [To locate this conversion option,select the Microsoft Excel worksheet object, click Worksheet Object(Spreadsheet Object in Word 6.0) on the Edit menu, and then click Convert.]

Choosing to convert the Microsoft Excel worksheet object results in anincorrect representation of your worksheet and causes the EMBED field codeto be modified, as shown in the following examples:
   Original field code:           {EMBED Excel.Sheet.5}   After converting to Chart:     {EMBED Excel.Chart.5 \s}				
The "Microsoft Excel Chart" option appears when the object has beenembedded, not linked.

In Word 97, you cannot view the field codes of an object that has theFloat Over Text property turned on. (To remove the Float Over Textproperty, right-click the object, select Format Object, select thePosition tab, clear the Float Over Text check box, and click OK.)
WORKAROUND
Method 1: On the Insert menu, click Object and create a new Microsoft Excel chart object.

Method 2: Instead of choosing Paste to insert the object, choose Paste Special and then click Paste Link.
STATUS
We are researching this problem and will post new information here in theMicrosoft Knowledge Base as it becomes available.
6.0 paste link embed winword word6 word7 7.0 word95 word97
Properties

Article ID: 120773 - Last Review: 09/13/2013 19:08:29 - Revision: 1.2

  • Microsoft Word 6.0 Standard Edition
  • Microsoft Word 6.0a
  • Microsoft Word 6.0c
  • Microsoft Word 95 Standard Edition
  • Microsoft Word 95a
  • Microsoft Word 97 Standard Edition
  • kbnosurvey kbarchive kbinterop KB120773
Feedback