Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Linked Picture of Cells Changes Size with Print Quality


View products that this article applies to.

Symptoms

In Microsoft Excel 2000, when you print or view a worksheet in Print Preview, and the worksheet contains a linked pasted picture, the output may be a different size than the size that you expect.

↑ Back to the top


Cause

This behavior can occur when the following conditions are true:
  • You copy cells and paste them as a picture that is linked to the copied cells.

    -and-
  • The printer that you are using has a default resolution other than 300 dots per inch (dpi).

    -and-
  • You change the resolution of the printer to a setting other than the default print quality for that printer.

↑ Back to the top


Workaround

To work around this issue, paste the cells as a picture that is not linked to the cells. This issue is likely to occur only on printers with default resolutions that are greater than 300 dpi, or on printers with resolutions that are not based on 300 and 150 dpi.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top


More information

If the default resolution of the printer is 600 dpi, and you change the resolution to 1200 dpi (if this setting is available for the printer), the printed picture may increase in size and be truncated. If you change the resolution to 300 dpi, the printed picture may be smaller.

↑ Back to the top


References

For more information about linked pictures, click Microsoft Excel Help on the Help menu, type linked objects in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top


Keywords: KB211633, kbprint, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 211633
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 241