Knowledge Base

XL97: Can't Drag Graphics from Internet Explorer

Article ID: 166829

Article Last Modified on 5/13/2003

APPLIES TO

This article was previously published under Q166829

SYMPTOMS

If you drag a graphics file from a Web page in Microsoft Internet Explorer and drop it into a worksheet in Microsoft Excel 97, the graphics file does not appear in the worksheet. Instead, a new workbook containing random binary characters (possibly including the words "GIF87" or "GIF89") is created, or the text from the ALT value of the graphic may appear in a worksheet cell.

CAUSE

This problem occurs because Microsoft Excel 97 does not support dragging graphics files from Internet Explorer. Instead of displaying the graphics file, Microsoft Excel 97 attempts to open the graphics file as though it were a text file.

WORKAROUND

If you want a graphics file in Internet Explorer to appear in a worksheet in Microsoft Excel 97, copy the graphics file and paste it into Microsoft Excel 97, by doing the following:

  1. In Internet Explorer, right-click the graphics file. On the shortcut menu, click Copy.
  2. Start Microsoft Excel 97 and click the cell where you want to paste the image.
  3. On the Edit menu, click Paste Special.
  4. Select Bitmap.
  5. Click OK.
The image will appear correctly.

STATUS

This behavior is by design in Microsoft Excel 97.

MORE INFORMATION

The problem described in this article will occur whenever you attempt to drag a .gif file or a .jpg file from Internet Explorer into Microsoft Excel
  1. It may also occur if you attempt to drag graphics files in other formats.
Note that Microsoft Word 97, which is included in Microsoft Office 97, does support dragging graphics files from Microsoft Internet Explorer.

Additional query words: 97 XL97

Keywords: kbweb kbprb KB166829


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.