Microsoft KB Archive/72574

{|
 * width="100%"|

Excel Err Msg: Cannot Open Printer Driver

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0

-

SUMMARY
In Microsoft Excel for Windows, when you attempt to print a document, you may get the error message &quot;Cannot Open Printer Driver.&quot; This error message can be caused by any of the following:


 * Various problems with the printer setup.
 * A problem with the temporary directory and/or available disk space.
 * A low-memory situation.
 * Selecting an inactive printer driver in the Control Panel.
 * No COMMDLG.DLL exists on the system. (This does not apply to Microsoft Excel version 5.0.).
 * The selected printer driver is damaged or corrupt.
 * Your workbook is corrupt.

MORE INFORMATION
In addition to the reasons listed in Microsoft Excel Help, this error may also occur because a temporary directory is invalid or available disk space is low. To verify this, do the following:


 * 1) Get to a MS-DOS prompt.
 * 2) Type set and press ENTER.
 * 3) A list of environment variables is returned. You should have a line similar to the following:

TEMP=
 * 1) Verify that  is a valid directory.
 * 2) Verify that you have at least 2 megabytes (MB) of available disk space (after Windows is running) on the drive on which  is located.
 * 3) If you confirm that there is no COMMDLG.DLL file on your hard drive, use your Microsoft Windows disks to obtain the file.

If you think that the printer driver selected may be damaged or corrupt, reinstalling it from the original disks may also resolve the problem.