Microsoft KB Archive/24571

Word: Can’t Update Excel Copy Picture with Word QuickSwitch

PSS ID Number: Q24571 Article last modified on 03-07-1997

=
========================================================= 3.00 3.01 3.02 4.00 MACINTOSH kb3rdparty kbole

Summary

When using QuickSwitch between Word versions 3.x or 4.00 and Excel, the message “No Drawing or Painting program active” may be returned. This message is given if an area of an Excel spreadsheet is copied as a picture (rather than actual data on the worksheet), and then Paste Link is selected from the Edit menu in Word.

To correct this problem, recopy the Excel area without holding down the SHIFT key (normal copy) and paste (Paste Link in Word 4.00) the area into Word.

= MORE INFORMATION =

The Copy Picture command in Excel copies the current selection as a picture to the Clipboard. To access the command, press the SHIFT key while selecting the Edit menu. The Copy command now reads Copy as Picture.

When QuickSwitching between Word and Excel, you must have a reference to the rows and columns defined on the Word document. The QuickSwitch link will not work if you copy the Excel area with the Copy Picture command because Word expects its path to lead to a graphics application because the object is in picture format.

For more information about the QuickSwitch (Edit Link) feature in Word 4.00, see pages 54-55 and 407-410 in the “Reference to Microsoft Word” manual. For more information about the QuickSwitch (Edit Link) feature in Word 3.0x, see pages 174 and 418-419 in the “Reference to Microsoft Word” manual.

KBCategory: kb3rdparty kbole KBSubCategory: Additional reference words: macword macword5 ====================================================================== ============================================================================= Copyright Microsoft Corporation 1997.