Can't Link to Worksheet with Exclamation Point in Name

This article was previously published under Q111941
This article has been archived. It is offered "as is" and will no longer be updated.
Symptoms
If you link information from a Microsoft Excel worksheet to anotherprogram (client program) and the worksheet name contains an exclamationpoint (!), one of the following problems may occur:

  • You receive an error message in the client program.
  • The information appears in the client program, but the link cannot be edited or updated.
Workaround
To avoid this behavior when you link information from a Microsoft Excelworksheet to a client program, make sure the worksheet name does notcontain an exclamation point. To rename a worksheet in a MicrosoftExcel workbook, point to Sheet on the Format menu, and click Rename onthe submenu.
More information

Microsoft Word for Windows

If you copy information from a worksheet when the name contains anexclamation point and click Paste Special in a document in Microsoft Word,the following options are available in the As list:

   Microsoft Excel Worksheet Object   Formatted Text (RTF)   Unformatted Text   Picture   Bitmap (Windows version only)				


If you click Formatted Text (RTF) and click Paste Link, the followingerror message appears when you click OK:
Word cannot obtain the data for the Microsoft Excel Worksheet link.
If you select any of the other available options, and click OK withthe Paste Link option selected, the worksheet information appears inthe Word document. However the information is not updated when youchange the data in Microsoft Excel.

In Microsoft Excel 97, if you select any of the options in the PasteSpecial Dialog Box and click Paste Link in Word 97, the followingerror message appears:
Word cannot obtain the data for the Microsoft Excel Worksheet link.

Microsoft Write (Windows Only)

If you copy information from a worksheet when the name contains anexclamation point, and click Paste Special in a document in MicrosoftWrite, the following options are available in the Data Type list:

   Microsoft Excel Worksheet Object   Picture   Bitmap   Text				


The Paste Link button is not available when you click the Text option.Note that this problem occurs even if the worksheet name does notcontain an exclamation point.

If you click any of the other options and click Paste Link, theinformation appears in the Microsoft Write document. However, theinformation is not updated when you change the source information. Whenyou edit the link in Microsoft Write, you receive the following errormessage:
Linked document is unavailable.
When you update the link using the Links dialog box, you receive thefollowing error message:
The source document cannot be found.

Make sure that the object still exists in the source document, the link is uncorrupted, and the source document is still available (that is, it has not been deleted, moved, or renamed).

5.00c 6.00 8.00 97 Word6 Word97 officeinterop ole xl5 xl95 xl97 wd97 XL
Properties

Article ID: 111941 - Last Review: 10/26/2013 12:02:00 - Revision: 2.0

  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • kbnosurvey kbarchive kbinterop kbprb kbualink97 KB111941
Feedback