Microsoft KB Archive/211451

= XL2000: Errors Printing Filled AutoShapes to PostScript Printer =

Article ID: 211451

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211451





SYMPTOMS
When you print a worksheet in Microsoft Excel 2000, the following error message may appear:

This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.

If you click Details, one or more of following error messages, or messages similar to these, may appear:

EXCEL caused an invalid page fault in module MSO97.DLL at 014f:307f3206.

-or-

EXCEL caused an invalid page fault in module KERNEL32.DLL at 014f:bff9a3c0.

-or-

MPREXE caused an invalid page fault in module MPRSERV.DLL at 014f:7fc012ae.

-or-

MPREXE caused an invalid page fault in module KERNEL32.DLL at 0137:bff78053.



CAUSE
This problem may occur when the following conditions are true:


 * You print to a PostScript printer.

-and-


 * The worksheet contains one or more drawing objects or AutoShapes.

-and-


 * You use a Windows Metafile graphic to fill one of the drawing objects or AutoShapes.

-and-


 * The Windows Metafile graphic you use contains one or more gradient fills or a large number of colors.

NOTE: This problem does not occur when you view the worksheet in Print Preview or when you print using a non-PostScript printer.



WORKAROUND
To prevent this problem from occurring in Microsoft Excel, do not print drawing objects and AutoShapes that are filled with complex Windows Metafile graphics to a PostScript printer.

To work around this problem, use one of the following methods:

Method 1
Print to a non-PostScript printer.

Method 2
Format the drawing object and/or AutoShape so that it is not printed when you print the worksheet. To do this, follow these steps:


 * 1) Click to select the drawing object or AutoShape.
 * 2) On the Format menu, click the first menu item (for example, AutoShape), and then click the Properties tab.
 * 3) Click to clear the Print object check box, and then click OK.
 * 4) Repeat these steps for each drawing object or AutoShape that is filled with a complex Windows Metafile graphic.

Method 3
Edit the Windows Metafile graphics files that you want to use and remove multiple gradient fills or a large number of colors.

NOTE: To do this, you must edit the graphics file in a program that is capable of editing and saving .wmf files.

Method 4
Convert the graphics to a different format (for example, .jpg or .gif), and then fill the drawing objects and AutoShapes with the converted graphics.

NOTE: To do this, use a program that is capable of opening .wmf files and saving them to a different format.



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



MORE INFORMATION
In Microsoft Excel, you can fill drawing objects and AutoShapes with a variety of backgrounds, including solid colors, patterns, gradient fills, textures, and pictures.

When you fill a drawing object or AutoShape with a picture, you can use any graphic file format that is supported by Microsoft Excel 2000.

