Microsoft KB Archive/191975

= XL98: Can't Link to Worksheet with Exclamation Point in Name =

Article ID: 191975

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q191975





SYMPTOMS
If you link information from a Microsoft Excel worksheet to another program (client program) and the worksheet name contains an exclamation point (!), 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 Excel worksheet to a client program, make sure the worksheet name does not contain an exclamation point. To rename a worksheet in a Microsoft Excel workbook, point to Sheet on the Format menu, and click Rename on the submenu.



Microsoft Word 98 Macintosh Edition
If you copy information from a worksheet when the name contains an exclamation 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

If you click Formatted Text (RTF) and click Paste Link, the following error 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 with the Paste Link option selected, the worksheet information appears in the Word document. However the information is not updated when you change the data in Microsoft Excel.

In Microsoft Excel 98 Macintosh Edition, if you select any of the options in the Paste Special Dialog Box and click Paste Link in Word 98 Macintosh Edition, the following error message appears:

Word cannot obtain the data for the Microsoft Excel Worksheet link.

Additional query words: officeinterop ole XL98 wd98

Keywords: kbinterop kbprb KB191975

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.