Microsoft KB Archive/175569

From BetaArchive Wiki
Knowledge Base

Article ID: 175569

Article Last Modified on 7/2/2007


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q175569


In Microsoft Excel 97, if you print a nonrectangular object, such as a drawing object or an AutoShape, that is filled with either a picture or a texture, the picture or texture may "leak out" of the object and fill a larger rectangular area in the printed output.

Note that the object appears correctly in print preview.


This problem may occur if you are printing to any of the following printers:

Canon BJC-210
Canon BJC-610
Canon BJC-4200


You may be able to work around this problem by adding a "ForceOpaque" line to the section in your Win.ini file that stores settings for the printer driver that you are using. To do this, follow these steps:

  1. On the Start menu, click Run. In the Open box, type Win.ini. Click OK.
  2. On the Search menu, click Find. In the Find What box, type Canon. Click Find Next. Continue to click Find Next until a line similar to either of the following is selected:

    • [Canon BJC-210,\\printerserver\printer]
    • [Canon BJC-210,LPT1]
    Then, click Cancel.
  3. Insert a new line below the "[Canon BJC-210,\\printerserver\printer]" line. Type the following text:


  4. On the File menu, click Save. Then, click Exit on the File menu.
  5. Quit and restart Microsoft Excel 97.

NOTE: After you make this change to your Win.ini file, objects that use semitransparent fills are still printed correctly in Microsoft Excel 97 even though the setting you changed is the ForceOpaque setting.


This problem may occur when you print a worksheet that contains a rectangular object that is filled with a picture and is rotated. Because the object is rotated, it is no longer considered rectangular.

When the worksheet is printed, the fill extends past the boundaries of the rectangle and fills the rectangular area that surrounds the rotated object.

It is not necessary to restart Microsoft Windows after you change the Win.ini file; however, it is necessary to quit and restart Microsoft Excel 97.

NOTE: If the workaround in this article does not correct the problem, contact Canon or your printer manufacturer to see if an updated driver that corrects this problem is available. You can access the Canon Web site at the following address:

The third-party contact information included in this article is provided to help you find the technical support you need. This contact information is subject to change without notice. Microsoft in no way guarantees the accuracy of this third-party contact information.

Additional query words: XL97 bubble jet bubblejet actt

Keywords: kbprb kbprint KB175569