The information in this article applies to:
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:
WORKAROUNDTo 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. MORE INFORMATIONMicrosoft Word for WindowsIf 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:
If you click Formatted Text (RTF) and click Paste Link, the following error message appears when you click OK: 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 97, if you select any of the options in the Paste Special Dialog Box and click Paste Link in Word 97, the following error message appears:
Microsoft Write (Windows Only)If you copy information from a worksheet when the name contains an exclamation point, and click Paste Special in a document in Microsoft Write, the following options are available in the Data Type list:
The Paste Link button is not available when you click the Text option. Note that this problem occurs even if the worksheet name does not contain an exclamation point. If you click any of the other options and click Paste Link, the information appears in the Microsoft Write document. However, the information is not updated when you change the source information. When you edit the link in Microsoft Write, you receive the following error message: When you update the link using the Links dialog box, you receive the following error message:
Additional query words: 5.00c 6.00 8.00 97 Word6 Word97 officeinterop ole xl5 xl95 xl97 wd97
Keywords : kbinterop kbualink97 kbdta offinterop |
Last Reviewed: May 2, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |